>>>>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 //:^)
>
>Larry, does the use of * instead of listing 2 or 3 field names really make a difference? As long as you don't use a calculated field or an "AS" clause the cursor is still a filtered copy.
>
>Barbara
I do believe so. If you have access to a large table give it a try and let me know what you come up with //:^)