Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why is Optimization 'Partial'
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Why is Optimization 'Partial'
Divers
Thread ID:
00052442
Message ID:
00052442
Vues:
88
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?)
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform