how to use index on a table used for searching using regex or like '%example%'
- by prafful
Dear all,
I want to use index on table where i m searching a string using regex '^searchkeywordname$|searchkeywordname' ,this is scanning whole table .how can i retrieve fast result using index or sumthing