>>>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