Index Maint Order of events...

I have a set of procedures that I have modified from
http://coolthingoftheday.blogspot.com/2007/06/sql-server-maintenance-scripts-from.html
My questions is what sequence should they be run in?
I am currently running them in the following sequence:
CHECKDB
INDEXDEFRAG
UPDATE STATISTICS
UPDATE USAGE
TIA!
David
That's really a matter of preference if you want to check the integrity
before or after defragging. Personally I would prefer to do it after so I
know that I have a sound db after moving all that data around.
INDEXDEFRAG
UPDATE STATISTICS
UPDATE USAGE
CHECKDB
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"David Hay" <david.hay@.gmail.com> wrote in message
news:6e483d8d-1fd8-4c9f-ab2f-727a66508692@.f3g2000hsg.googlegroups.com...
>
> I have a set of procedures that I have modified from
> http://coolthingoftheday.blogspot.com/2007/06/sql-server-maintenance-scripts-from.html
> My questions is what sequence should they be run in?
> I am currently running them in the following sequence:
> CHECKDB
> INDEXDEFRAG
> UPDATE STATISTICS
> UPDATE USAGE
> TIA!
> David