>>I am trying to determine why my SQL statement is returning
>>'Partial' Optimization instead of full.
>>
>>SELECT Acctnum, DeptNum;
>> FROM Chg;
>> WHERE Chg.Acctnum='5555555';
>> INTO CURSOR cResult
>>
>>Chg is 2+ Million Records
>>There is an Index 'Acctnum' in Table Chg (Not Primary).
>>Acctnum is C 7
>>
>>SYS(3054) Returns
>> 'Using index tag acctnum to rushmore optimize table chg'
>> 'Rushmore optimization level for tabl chg: Partial'
>>
>>Am I missing something?
>
>If SET DELETED ON, you should alse have index on DELETED().
Ditto on the above, but also...
Unless absolutely neccesary you should run...
SELECT * FROM Chg WHERE Chg.Acctnum='5555555' INTO CURSOR cResult
It will be almost instantaneous since it will be using the table as is, the equivalent of "USE chg AGAIN IN 0 ALAIS cResult". Your code will be copying fields to a temp file.
HTH //:^)