>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().
Edward Pikman
Independent Consultant