테이블 압축 여부 확인하기

MS SQL 2008 Enterprise에서 Page 압축을 지원하는데, 압축 여부를 확인하기

 

1. 테이블 압축 여부 확인하기

SELECT I.name,
        P.data_compression,
        P.data_compression_desc
FROM sys.partitions AS P
JOIN sys.objects AS O 
        ON P.object_id=O.object_id
JOIN sys.indexes AS I 
        ON P.object_id=I.object_id AND P.index_id=I.index_id
WHERE I.object_id IN (
        SELECT object_id 
        FROM sys.objects 
        WHERE name='테이블이름')

2. 결과 확인