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?
Thanks,
Patrick
Senior Analyst/Programmer
Lexington, KY
(Basketball, Bourbon & Horses... What Else Matters?)