er.mayankshukla (8/20/2014)
Hello Experts,I had done a page compression on an archive Table on my Dev Server.
And it significantly reduced the size of the table.
I have a non clustered index and a clustered index on that table
After doing a page compression on the table, if I rebuild my index wouldn't it be same as compressing individual indexes
Further on Gail's answer
😎
USE [DATABASE NAME]
GO
ALTER INDEX [INDEX NAME] ON [SCHEMA].
REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE) -- [OTHER OPTIONS])
GO