Answer Detail: RE: Increase %LIKE Operator Performance

GeekInterview.com > Interview Questions > Oracle > Database Administration

Print |

Question: Increase %LIKE Operator Performance

Answer: How do you increase the performance of %LIKE operator?

October 10, 2008 02:00:52	#1
ravinder.pathania	Member Since: January 2008 Total Comments: 2
RE: Increase %LIKE Operator Performance
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.