2008 Rebuild Index Maintenance Plan

• SQLSACT

  SSC-Insane

  Points: 21773

  More actions

  January 20, 2012 at 4:11 am

  #249523

  Hi Guys

  When executing a Maintenance Plan to rebuild indexes, I noticed that it starts with an initial SELECT statement, what is this statement for?

  I have a Maintenance Plan that is stuck on this SELECT statement and not getting to the ALTER INDEX part. I get this info from sp_who2.

  Is this a performance problem or something wrong with the maintenance plan?

  Thanks

• stephen7272

  SSC Enthusiast

  Points: 165

  More actions

  January 20, 2012 at 5:24 am

  #1436389

  Hi, can you post the select statement.

• padhis

  SSCommitted

  Points: 1762

  More actions

  January 20, 2012 at 9:08 am

  #1436581

  did your maintenance plan execution completed with any error message? pls post your message.