>Can someone let me know if the following is optimized?
>
>scan for filename.fil_total = filename.fil_subtot
>
>I have an index on total.
>
>Thanks
>Pat Murphy
You need an index on fil_total. Yes, it will be optimized. However, it *might* be faster to do:
SET ORDER TO TAG fil_total
SEEK FileName.fil_subtot
SCAN WHILE Fil_Total = FileName.Fil_SubTot
ENDSCAN
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer