exec sp_estimate_data_compression_savings 'dbo', 'test', NULL, NULL, 'ROW' --行圧縮
exec sp_estimate_data_compression_savings 'dbo', 'test', NULL, NULL, 'PAGE' --ページ圧縮
--TABLEの場合
ALTER TABLE [dbo].[test] REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)
--INDEXの場合
ALTER INDEX [index_name] ON [dbo].[test] REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme