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:
01139976
Views:
10
>>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform