Tuning the LIKE-clause (by using reverse key indexes)
For tuning Like operator (like '%SON') is to create a REVERSE index - and then programmatically reverse the LIKE-clause to read LIKE 'NOS%'
Steps:
CREATE INDEX Cust_Name_reverese_idx
ON customer(Cust_Name) REVERSE;
2. Programmatically reverse the SQL LIKE-clause to read '%saliV%':
SELECT * FROM customer WHERE Cust_Name LIKE '%Vilas%'
New Query:
SELECT * FROM customer WHERE Cust_Name LIKE '%saliV%';
No comments:
Post a Comment