need help on oracle indexes
Posted on 2014-09-30
I came across an blog , which says the below lines
One obscure trick for indexing queries with a leading wildcard character (like '%SON') is to create a REVERSE index and them programmatically reverse the SQL like clause to read "like 'NOS%'", effectively indexing on the other side of the text, clumsy, yet effective.
I have an table , comments . I need to perform %<>% operation on two columns title and comments . Here title is varchar2(4000) and comments is clob.
Can any one help how i can implement the above solution , to speed up performance. I have been asked not to use oracle text indexes.
title like '%sam%'
or subject like '%sam%')