Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimization of a JOIN
Message
De
04/03/2008 15:44:19
 
 
À
04/03/2008 14:50:17
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01298581
Message ID:
01298628
Vues:
28
Walter,

>BTW, get rid off the deleted tag. It does not speed up your query (except in very specific circumstances). Full optimization does not mean that it is most optimal.

that used to be one of my standard first checks. It changed to making sure if the index was at least binary and then thinking on deleting<g>.
On the off chance that the deleted() index helps at least somewhere in the app the slight slurp of the pure bitmap of a binary index helps MUCH more than I had imagined after first readin about it.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform