>>>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