MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: index usage dependent on in(group) content
Posted by: Rick James
Date: March 24, 2009 09:06PM

MySQL generally cannot use an index for the things in an OR. If, by turning it into a UNION, it can then use an index for that field, it is likely to run much faster.

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


Subject
Written By
Posted
index usage dependent on in(group) content
Allan Kelly
March 22, 2009 02:28PM
Re: index usage dependent on in(group) content
Rick James
March 23, 2009 11:01PM
Re: index usage dependent on in(group) content
Allan Kelly
March 24, 2009 05:32PM
Re: index usage dependent on in(group) content
Rick James
March 24, 2009 09:06PM
Re: index usage dependent on in(group) content
Rick James
March 24, 2009 09:08PM


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.