Re: 5.6 Adding new index, it does not get used
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?
Subject
Views
Written By
Posted
1532
July 15, 2014 03:00PM
791
July 16, 2014 09:13AM
Re: 5.6 Adding new index, it does not get used
752
July 16, 2014 11:13AM
744
July 17, 2014 03:49PM
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.