Hi!

Try to use the SET DELETED OFF before the query. Than see if it is optimized. When SET DELETED ON, Rushmoure requires the 'deleted()' index tag fro optimization in SET DELETED ON mode. This is not required to add, if you have less than 55% of deleted records in the table (usually it is no more than 1% when you have admin programs to pack tables in database often).

HTH.

>HI
>
>I want to run a SELECT Statement from 2 tables like this:
>
>SELECT *;
> FROM Table1 ;
>LEFT OUTER JOIN Table2;
>ON Table1.Key = Table2.Key;
>WHERE Table1.Field = cValue;
> AND Table2.Field = cValue2
>
>The only problem, is that this isn't optimised if I only populate cValue2.
>
>Any ideas on how I can speed this up?
>
>Thanks
>Kev