Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Sergey, Thanks for not giving up on me. I "get it".
As for the advice on adding a bunch of indexes indiscriminately, I will follow your advice of finding the slow ones and concentrating on those.
I estimate there are probably no more than 20 deleted records in all the tables in my application per installation. Deletes are seldom performed. I am going to hope that means I do not need any indexes on deleted(). If that is an incorrect assumption with regard to optimization please let me know.
Otherwise, I have learned a lot and I believe I have a good plan for going forward. Thanks all for the assistance.
John
Précédent
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