Hi all,
I'm using a like "%variable_name%" condition in my SQL query for a large table (>1 million records) and it takes a long time for retrieval.
The field is a character field and is already indexed.
Any strategies that can be used to speed up this query?
Thanks in advance.
Yau