select * from table where column like '%value%'It takes 10 seconds to return a value and I have a bitmap index which doesn't seem to help. I have looked at function indexes but cannot figure out one that would work. Any suggestions would be appreciated.
select * from table where instr(column, 'value') > 0;
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.