On Oct 27, 2006, at 11:50 AM, Dan Nelson wrote:
> MySQL is just giving you as much information as it can without
> running the query. It knows how it will go about running the query
> "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?