markd_mms wrote:

>wow down to 141 ms! but now searching on ITEM.TITLE by itself has gone
>up to 1.5 seconds from about 300ms showing 14010 unindexed reads on
>ITEMINFORMAT. is there a happy medium or should i just use a different
>query depending on what i'm searching for?
>
>TIA
>
>
>

An important thing that I forgot to mention.

Are your indices statistics up to date ?

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br