Re: Simple query not using index
This also happens in a stock mysql 5.1.31 installed on ubuntu 9.04 server 64-bit, so you can rule out my use of xtradb/innodb plugin.
Some more investigation also revealed that when I remove the multi-column index index_pictures_on_user_id_and_is_private, then the query always uses index_pictures_on_user_id and everything is fine. However, one would think that dropping index_pictures_on_user_id would be the right choice to remove a redundant index, but when I do so, the query NEVER uses the index_pictures_on_user_id_and_is_private, and always does a table scan. Can anyone help?
Subject
Views
Written By
Posted
4417
August 05, 2009 09:30AM
Re: Simple query not using index
2335
August 07, 2009 02:54PM
2092
August 07, 2009 04:15PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.