Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How often to rebuild/reorganize indexes?
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01139936
Message ID:
01139979
Views:
11
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
Previous
Reply
Map
View

Click here to load this message in the networking platform