Various recommendations that have come to me via email. Dear BLOGGER checker, I am a REAL PERSON, see one of the drafts where I have given you my phone number to reach me.
CREATE INDEX lsc_i ON lsc_t(NAME);SELECT /*+INDEX(LSC_T,LSC_I)*/ ID, NAME, birthdate FROM lsc_t 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%';