Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why is Optimization 'Partial'
Message
De
30/09/1997 15:02:06
Larry Long
ProgRes (Programming Resources)
Georgie, États-Unis
 
 
À
30/09/1997 12:09:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00052442
Message ID:
00052500
Vues:
35
>>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().

Ditto on the above, but also...

Unless absolutely neccesary you should run...

SELECT * FROM Chg WHERE Chg.Acctnum='5555555' INTO CURSOR cResult

It will be almost instantaneous since it will be using the table as is, the equivalent of "USE chg AGAIN IN 0 ALAIS cResult". Your code will be copying fields to a temp file.

HTH //:^)
L.A.Long
ProgRes
lalong1@charter.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform