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'); +------------------+-------+---------------+------------+---------+------+-- ----+------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +------------------+-------+---------------+------------+---------+------+-- ----+------------+ | ship_to_customer | range | state_code | state_code | 3 | NULL | 433 | where used | +------------------+-------+---------------+------------+---------+------+-- ----+------------+ mysql> EXPLAIN SELECT * FROM shipping USE INDEX (state) WHERE state IN ('TN','NY','MN','LA'); +------------------+------+---------------+------+---------+------+------+-- ----------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +------------------+------+---------------+------+---------+------+------+-- ----------+ | ship_to_customer | ALL | state_code | NULL | NULL | NULL | 2298 | where used | +------------------+------+---------------+------+---------+------+------+-- ----------+ Anyone have any suggestions as to where I could look to fix this up? -- Mike Miller -- Happy 20'th Birthday, Mr. Smiley :-) http://research.microsoft.com/~mbj/Smiley/Smiley.html --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php