| Using index in like '%value%' [message #53409] |
Wed, 18 September 2002 05:45  |
Tanya
Messages: 3
Registered: May 2002
|
Junior Member |
|
|
Hello,
I have select statement as primitive as that :
select text
from some_table
where UPPER(text) like '%VALUE%'
There are the question:
What index could help me in this situation?
Even if I have function based index for UPPER(text) it won't choose it because of like '%VALUE%'.
I know that SQL server foes by index for this kind of queries. I believe that Oracle has to have some solution too.
Thank you for the suggestions.
Tanya
|
|
|
|
| Re: Using index in like '%value%' [message #53416 is a reply to message #53409] |
Wed, 18 September 2002 11:52  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
there is no solution that I know of outside of Context/Intermedia/Oracle-Text.
If you use like 'VALUE%' then you are able to use indexes because it can use the leading portion of the column.
Using instr(upper(col), 'VALUE') > 0 wouldn't help either.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
