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.
Per visualizzare gli articoli della Knowledge Base di livello avanzato, è necessario aver effettuato l'accesso e disporre di un contratto di manutenzione in essere.
© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center