>Hello Experts...
>
>The following query takes almost 5 minutes to show results on a table containing 290K records. How can I optimatize it ?statement:
>
>

>
>SELECT itm_numb,itm_desc FROM A WHERE itm_desc LIKE '%TOOLS%'
>
>

>
>The table is indexed on both fields. The code page matches and is set to 1252 (Windows ANSI), of both the table and the envirement.
>The RUSHMORE optimizer (SYS(3054, 1) returns :none.
>
>Any idea ?
>
>Raz

LIKE command is optimizable only if you search at the beginning of the string:

LIKE 'TOOLS%'
but the way you use it it is not, no matter if you have index or not.