On Oct 27, 2006, at 11:50 AM, Dan Nelson wrote:
MySQL is just giving you as much information as it can without
actually
running the query. It knows how it will go about running the query
(so
"type" is known absolutely), but it doesn't know exactly what it
will get
(so "rows" is only a guess). Nothing wrong with that.
If "type" is known absolutely, and is "ALL", as it was in this
case, why would EXPLAIN ever report a "rows" value less than the
number of rows in the table ( as it did here )?
At risk of sounding too much like Bill Clinton, what exactly does
"ALL" mean, then?
--
David Hillman
LiveText, Inc
1.866.LiveText x235