Rebuild Partitioned Indexes

  • When you have to rebuild an index that has partitions do you have to specify the partitions within the indexes or will simply identifying the index like I have written below do the trick?

    USE [TestDB]

    GO

    ALTER INDEX [in_tbl_doc2_address_address_id] ON [TestDB].[tbl_doc2_address] REBUILD WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = ON, ONLINE = OFF )

    Thanks,

    Shawn

  • Annoying to see no reply for this..

  • http://msdn.microsoft.com/en-US/library/ms189858(v=sql.105).aspx

    See link. It's an either by partition or all.

    *****

    Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P

  • Its ok to run the query you have.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply