Typically we would have the following patterns when we use like operator.
SEARCH-STRING% %SEARCH-STRING %SEARCH-STRING% SEARCH%STRING
1. a)The SEARCH-STRING% will perform INDEX RANGE SCAN data in least possible time.
b)Also uses INDEX FULL SCAN when you have only indexed column list in the queries.
c) If multiple predicates used, this may loose […]
Follow Me!!!