Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Cristof,
>Right. But when I read this thread I got the impression that the new rule is: "Never add an index on DELETED() unless you find in tests that it improves performances significantly." I think, the rule should be "Always add an index on DELETED() unless you find in tests that this index slows down your application (significantly)".
So should i add several indexes which the optimizer rarely use, but doesn't optimize performance ? I think not. As we all know indexes delay concurrency and performance when appending records.
The general rule has alway been. If you don't need a particular index, don't create them.
Walter,
Précédent
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