Hi Al
If you want to use sys(3054,1) to determine Rushmore optimization without a deleted tag, just SET DELETED OFF, run the query and SET DELETED ON. That way you'll see when you have full optimization.
>>Hi everyone,
>>
>>I have 2 index file and I use SQL select to make a query but they don't optimize (I check with sys(3054,1)), here is my code :
>>
>>sele 1
>>use customer inde cust1.idx
>>
>>sele 2
>>use sales inde sales1.idx
>>
>>sele s.cust_id,c.cust_name,s.sales_qty from customer c, sales s where s.cust_id=c.cust_id order by s.cust_id into cursor tmp
>>
>>Anyone knows why this is happend and also it doesn't optimize if I have more than one field on index file (i.e : inde on cust_id+cust_name to idxname)
>
>I seem to remember something about SYS(3054) never showing "fully optimized" if you have SET DELETED ON and you don't have an index tag on DELETED(). There have been some major discussions here on the value of a tag on DELETED() but the consensus seems to be it slows things down unless you have a lot of deleted records. So, if this is your case, although SYS(3054) is showing less than full optimization it is still effectively the best you're going to get.