Over time index fragmentation may lead to some degraded database operations and inefficient use of space within the database. The Rebuild Index task rebuilds indexes to remove logical fragmentation and empty space, and also updates index statistics. Table column statistics can be updated by running the Update Statistics task to avoid bad query plans. It is important to schedule this task to run regularly for best results. Advanced users may prefer to monitor their database to decide when maintenance should be executed and in which capacity.
Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les articles de la base de connaissances avancés.
© ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center