List:General Discussion« Previous MessageNext Message »
From:David Hillman Date:October 27 2006 5:06pm
Subject:Re: Optimizer Bug?
View as plain text  
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


Thread
Optimizer Bug?David Hillman25 Oct
  • Re: Optimizer Bug?Dan Buettner26 Oct
    • Re: Optimizer Bug?David Hillman27 Oct
      • Re: Optimizer Bug?Dan Nelson27 Oct
        • Re: Optimizer Bug?David Hillman27 Oct
          • Re: Optimizer Bug?Dan Nelson27 Oct