Monday, January 11, 2010

Laurent Schneider � How to tune WHERE NAME LIKE ‘%ABC%’

Laurent Schneider � How to tune WHERE NAME LIKE ‘%ABC%’:

CREATE INDEX lsc_i ON lsc_t(NAME);
SELECT /*+INDEX(LSC_T,LSC_I)*/ ID, NAME, birthdate
FROM lsc_t WHERE NAME LIKE '%ABC%';