Oracle Scenarios Question:

Download Job Interview Questions and Answers PDF

Explain How do we increase the performance of %LIKE operator?

Oracle Scenarios Interview Question
Oracle Scenarios Interview Question

Answer:

The wildcard char % can be placed in one of three ways:

%searchwordhere%
searchwordhere%
%searchwordhere

The searchwordhere% is the fastest because it can use an index if one is specified on that column. The other two %searchwordhere%, and %searchwordhere would never use the index even if one is specified and thus result in slow table scans.

Download Oracle Scenarios Interview Questions And Answers PDF

Previous QuestionNext Question
Explain the total process of eim?Explain If the SQL * Plus hangs for a long time, what is the reason?