At 04:09 PM 2/18/02, Chris Boget wrote: > > I couldn't find anything like this in my MySQL book or in the on line help. > >Could this be what you are looking for? > >http://www.mysql.com/doc/E/X/EXPLAIN.html > >Not sure exactly what you need to know... > >Chris
Sorry if I wasn't clear. I've read that page at least 4 times just today, along with the relevant chapters in Paul's MySQL book. What I can't find is any reference to the term "Select tables optimized away", which is what EXPLAIN returned with the select statement I was playing with. I'm assuming it is EXPLAIN's response to a not so useful SELECT statement, but thought I would ask just to be sure. I'm one of those anal people that sit here and try queries all day before putting them into a routine. Trying to use the EXPLAIN feature to milk the last little bit of speed I can get out of each SELECT. Cary --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
