>>Hi Andreas!
>>
>>Did you have an index on Deleted() expression too? It seems like your
>>filter is partially optimized...
>>
>>Have a happy day
>>Vladimir Shevchenko
>>
>Can you explain why an index on Deleted() is important for optimization?
>Is the effect of not having a index on Deleted() about the same as not having
>a index on another field which is part of the filter? Thanks!
>
>Paul Wei
Hi Paul,
Because in a SQL SELECT Foxpro must check the result set for deleted records to weed them out ( if so desired ). The speed of this is enhanced with an index like filtering on any other field with an index.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.