Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Effect of creating indexes on the fly?
Beginner programmer question:
I'm reworking a VFP6 database written by another programmer using tables from an FPW26 app (which is still being processed in part by FPW26). The main table has a field named 'LNAME' which has a regular ascending index.
However, for this routine, I really need an index tag for UPPER(LNAME).
If I create this index within the routine using INDEX ON UPPER(LNAME) TAG LAST ASCENDING, will the new index be added to the .CDX file, or will it exist only for the current session? Will it cause 'index bloat'? Will it alter the index structure of the table? Are there any other considerations I should be aware of?
Thanks,
Neil Preston
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement