MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Not using index properly in 4.1.7
Posted by: F de Bruijn
Date: December 08, 2004 01:51PM

I used the FORCE INDEX option allready but with no success. The EXPLAIN says that it will use the index but the 'rows' column show that it has to search throug all the records. So it is not working for me.

Regards,

F. de Bruijn

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Not using index properly in 4.1.7
3544
F de Bruijn
December 07, 2004 03:22AM
Re: Not using index properly in 4.1.7
1975
Harrison Fisk
December 07, 2004 08:41AM
Re: Not using index properly in 4.1.7
2025
F de Bruijn
December 07, 2004 09:47AM
Re: Not using index properly in 4.1.7
2108
Harrison Fisk
December 08, 2004 11:31AM
Re: Not using index properly in 4.1.7
2078
F de Bruijn
December 08, 2004 01:51PM
Re: Not using index properly in 4.1.7
1932
F de Bruijn
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.