Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why is Optimization 'Partial'
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Why is Optimization 'Partial'
Miscellaneous
Thread ID:
00052442
Message ID:
00052442
Views:
83
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?)
Next
Reply
Map
View

Click here to load this message in the networking platform