July 23, 2013 at 12:24 pm
is this syntax right for compression. I have a table which is partitioned, has a clus idx and two nc index.. i want enable page level compression on all indices and partitions..is this syntax right? Thanks
ALTER INDEX [PK_CluIndx] ON [dbo].[MyTable] REBUILD PARTITION = ALL WITH ( DATA_COMPRESSION = PAGE, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF ) GO
ALTER INDEX [Nc_1] ON [dbo].[MyTable] REBUILD PARTITION = ALL WITH ( DATA_COMPRESSION = PAGE, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )
ALTER INDEX [NC_2] ON [dbo].[MyTable] REBUILD PARTITION = ALL WITH ( DATA_COMPRESSION = PAGE, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply