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!

Which is best one out of LIKE and INSTR in terms of performance

605321Nov 29 2007 — edited Dec 4 2007

Hi,

My situation is to compare a string in a column values. Which is the best choice in terms of performace?

In my situation, Like is the one which hits the table for the entire record set where as INSTR is used in the condition control statements.

Let me know your comments

Regards,
K.Vijay

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 1 2008

Added on Nov 29 2007

6 comments

3,661 views