Difference Between T-SQL Reindex and Maint Plan Reindex

Last Post 20 May 2009 12:15 PM by BMWGuy. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
BMWGuy
New Member
New Member

--
20 May 2009 12:15 PM
Is there any difference between running a T-SQL statement:

alter index all on TBL1 rebuild


and creating a Maintenance Plan to rebuild indexes?

If not, why does the Maint Plan take so much longer to run?


You are not authorized to post a reply.

Acceptable Use Policy