MySQL Forums
Forum List  »  InnoDB

Re: 5.6 Adding new index, it does not get used
Posted by: Paul Williamson
Date: July 16, 2014 11:13AM

Actually, it seems Explain does show the index as being used when I do a select '=', instead of a select like '%...%'. I noticed that select like '...%' works too. So there seems to be no problem, though I'd like to understand why the index is apparently not used for like '%...%' - does that require a fulltext index?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: 5.6 Adding new index, it does not get used
752
July 16, 2014 11:13AM


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.