Thread: sp_MSforeachtable

Thanks to both of you.  I really appreciate the reply and advice against moving forward with this. ..bob > Is sp_MSforeachtable the best approach to maintain the rebuilding of all > indexes > for all tables in a database? > thanks in advance, > ..bob

Hi Bob, sp_MSforeachtable stored procedure is a undocumented stored procedure. It is always best to avoid any undocumented procedure in a production environement. Regards, Balaji > Is sp_MSforeachtable the best approach to maintain the rebuilding of all > indexes > for all tables in a database? > thanks in advance, > ..bob

No Bob , definetely No. Because  you need rebuild/reorganize only fragmented indexes and in most cases I have seen  you will need to update statistics to speed up the query Read the link http://ola.hallengren.com/ > Is sp_MSforeachtable the best approach to maintain the rebuilding of all > indexes > for all tables in a database? > thanks in advance, > ..bob

A Maintenance plan is probably your best option. > Thanks to both of you.  I really appreciate the reply > and advice against moving forward with this. [quoted text clipped - 5 lines] > > thanks in advance, > > ..bob

Why? Not that I disagree, but  readers would likely appreciate having more to base the decision as to whether to accept your advice than the fact that they like your name. :-) > A Maintenance plan is probably your best option. > [quoted text clipped - 7 lines] >>> thanks in advance, >>> ..bob