Oracle Scenarios Question:
Explain How do we increase the performance of %LIKE operator?
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.
%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.
| Previous Question | Next Question |
| Explain the total process of eim? | Explain If the SQL * Plus hangs for a long time, what is the reason? |