MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: index is not used why?
Posted by: Peter Brawley
Date: March 24, 2009 08:15AM

> MySQL won't use more than one index in a query.

No longer so, see http://dev.mysql.com/doc/refman/5.1/en/index-merge-optimization.html

PB
http://www.artfulsoftware.com



Edited 1 time(s). Last edit at 03/24/2009 08:17AM by Peter Brawley.

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


Subject
Written By
Posted
index is not used why?
Thomas Jüntgen
March 18, 2009 05:32AM
Re: index is not used why?
Rick James
March 19, 2009 07:45PM
Re: index is not used why?
Thomas Jüntgen
March 24, 2009 08:09AM
Re: index is not used why?
Peter Brawley
March 24, 2009 08:15AM
Re: index is not used why?
Rick James
March 24, 2009 08:11PM
Re: index is not used why?
Peter Brawley
March 24, 2009 08:34PM
Re: index is not used why?
Thomas Jüntgen
March 26, 2009 03:49AM


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.