Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How often to rebuild/reorganize indexes?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01139936
Message ID:
01139979
Vues:
12
This message has been marked as a message which has helped to the initial question of the thread.
>>>How is it recommended that I rebuild or reorganize my indexes? Daily or Monthly? Does rebuilding include reorganizing or are they different things?
>>
>>It varies according to your database update frequency and the selection of your clustered index.
>>
>>Independently of these factors, for "regular" database, I do the complete task on a weekly basis (because most of my databases are used Monday-to-Friday from 9 to 5).
>
>Thanks Eric. When you "complete task" do you mean doing a rebuild and a reorganize?

I select all options in the Maintenance plan wizard.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform