Kevin,
In addition to Vlad's suggestions, one thing I often forget is key tags that are UPPERed().
I.e. INDEX ON UPPER(field) TAG field
Rushmore only fully optimizes if the search expression exactly matches the tag expression.
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
Daniel