Problem using LIKE with FORCE INDEX...
Hi.. I have a question, because when I try to use the LIKE sentence with the FORCE INDEX sentence, the LIKE sentence ignore it.?? I have the next SQL
EXPLAIN SELECT filename FROM users u force index (uniqUsername) where username like "%ill%" ;
The result is:
possible_keys = NULL
key = NULL
Where that table has a index named "uniqUsername" ??..
Why the LIKE sentence not repect it?
Thank's
Subject
Views
Written By
Posted
Problem using LIKE with FORCE INDEX...
8216
February 04, 2008 11:02AM
4275
February 04, 2008 05:08PM
3642
February 06, 2008 02:34AM
3511
February 13, 2008 01:19AM
3471
March 12, 2008 09:40AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.