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.
Sie müssen sich anmelden und über einen gültigen Servicevertrag verfügen, um auf Premium-Wissensartikel zugreifen zu zu dürfen.
© ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center