Rakesh Gautam

• Jul 5th, 2005

 

never user '%' before a seraching word 
e.g '%TABLE%'  
 
Always uses 'TABLE%' 

J Lehew

• Aug 25th, 2005

 

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.