Hi Sergey
It may be tied in with SET DELETED OFF. The different environments may be acting differently.
Generally, I have not added a Deleted() index. Thete is not one in this case.
Time for some more testing. I'll get back to you.
Thanks
Geoff
>>Hi Geoff,
>>
>>I think that your problem is different than the Tore`s one.
>>The CPCURRENT() and CPBDF() are the same and the optimization level is partial in your case. I >>have had the same problem as Tore, but the code pages were different and optimization level was >>none in our case.
>>
>>It seems to me that VFP9 indicates patrial optimization if SET DELETED ON, too.
>>
>>Ladislav
>Do you've index on DELTED() or not? I'm not saying that you've to add it but pointing out that it cause optimization to be partial which may or may not have affect on the query speed.
>
>>The same select in VFP8 on the same table reports
>>
>>
Using index tag Custinvno to rushmore optimize table invcust
>>Rushmore optimization level for table invcust: Full
>>
>>Accepting that this may be the issue, I should add the deleted() index to all my tables??
>>
May all your weeds be wildflowers