Mike Yearwood
Toronto, Ontario, Canada
Hi Greg
>Greetings,
>
>A few weeks ago there was a thread concerning the harm or value of creating an index on DELETED(). I was very interested in this because AccPac Pro Series puts a deleted() index on every single table in the system. The overall concensus was that this would be a performance penalty and that I should be able to remove the deleted() indexes altogether.
>
>This week I started looking into that and have found another wrinkle. 90% of the queries in AccPac Pro Series include .NOT. DELETED() in them. In other words AccPac does not set deleted on, they omit deleted records in each query specifically. So now I wonder if I remove the deleted index will I not have a performance penalty on the large tables because the query will no longer be optimizable. Obviously there is no way I can go through all the source code and change all the queries so is the best thing to just leave the deleted() indexes in place?
>
Such queries would be partially optimizable. Fully optimizable doesn't necessarily mean faster.
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