Oracle Scenarios Question:
Download Questions PDF

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


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


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?