>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

If you must use LIKE , I suggest logging queries and creating custom indexes based on the queries used most often, what ever 'most often' means in your situation.