MySQL Forums
Forum List  »  Performance

Re: Not using index properly in 4.1.7
Posted by: Harrison Fisk
Date: December 08, 2004 11:31AM

Hrm.

For some reason it is deciding not to use the index and instead is doing a full table scan. Try to force the index in 4.1 and see what it says for EXPLAIN again.

To force the index to be used do:

SELECT....FROM table FORCE INDEX (key) WHERE...;

Post the new EXPLAIN after you try the force in 4.1.

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
3110
December 07, 2004 03:22AM
1784
December 07, 2004 08:41AM
1861
December 07, 2004 09:47AM
Re: Not using index properly in 4.1.7
1944
December 08, 2004 11:31AM
1900
December 08, 2004 01:51PM
1743
December 09, 2004 09:50AM


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.