If it thinks it will retrieve more than a third of the records, the
index will not be used.
[EMAIL PROTECTED] wrote:
>I get the following results when doing a SELECT off a single table I have.
>What's bizarre is that the index is no longer used when i expand my list of
>states to be included.
>
I get the following results when doing a SELECT off a single table I have.
What's bizarre is that the index is no longer used when i expand my list of
states to be included.
mysql> EXPLAIN SELECT * FROM shipping USE INDEX (state) WHERE state IN
('TN','NY');
+--+---+---
