Isn't the choice in the the "type" col of Explain a "full index scan"
rather than a full table scan ?My understanding was that the "ALL" stands
for "full table scan ".
Thanks,
Mariella
On Tue, Jul 29, 2008 at 11:03 AM, Mary Bahrami <[EMAIL PROTECTED]>wrote:
> The optimizer made the correct ch
The optimizer made the correct choice when it did a full table scan
where there were few rows...I wouldn't want to override the optimizer in
this case.
Check that you updated statistics between these two queries
(information_schema.statistics.cardinality).
-Original Message-
From: MySQLFo
