TECTED]>wrote:
> 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.
Hi All,
I have been using mysql 5.1.26-rc on Linux and configured to log queries
that do not use index through
log-queries-not-using-indexes
I would like to ask two questions, please:
1)
I have noticed that in some cases some queries get logged because a scan of
the index on a field is executed.