SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INSTR vs LIKE '%XXX%'

399913Jul 28 2003 — edited Jul 29 2003

Hi

I am curious as to which approach would be the most efficient when searching for a word/substring within a large text field.

Would it be more efficient to use:
WHERE INSTR(column_name, 'search_word') > 0

OR
WHERE column_name like '%search_word%'

Thanks
Ozzy

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 26 2003

Added on Jul 28 2003

5 comments

1,940 views