Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is it reasonable to have index on DELETED()?
Message
De
10/03/1999 14:45:19
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Is it reasonable to have index on DELETED()?
Divers
Thread ID:
00196021
Message ID:
00196021
Vues:
86
I'm using a lot of sql selects to select data from big free dbfs.
Those tables have very few deleted records and where clauses are written so
that Rushmore finds always a index tag to use.
SET DELETED is ON always.

Will the performance increase if I add

INDEX ON DELETED()

to those tables? Will select queries run then faster?
I have read some recommendations to have index on deleted() in each table
to avoid sequential scanning of the deleted records by select. Is this true?
Andrus
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform