>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.