>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?
List all of your index expressions for this table..I was thinking that perhaps your index on acctnum was UPPER(acctnum) or something like that.