Topic: Type of compression for an index (data_compression): ROW or PAGE.
Compression of numerical types is produced for type ROW in the core, and varchar, etc. is not compressed. Compression is produced in line.
Compression at first is produced for type PAGE in line, then then prefix compression, then dictionary compression. In this case line types are well compressed. So often repeating substrings are located in special area of page, and already links to these substrings are stored in columns in .
Question in the following.
There will be an index on the big table of type nonclustered index on dbo. Table (type_id, object_id, dt) where columns have following types: type_id int, object_id int, dt datatime.
What type of compression to select for such index? If sense in compression PAGE? After all all columns of an index of integral types. It seems to me that for them compression of a prefix and compression of the dictionary or at all will not be is produced, or links to a prefix and the dictionary take more places, than the data.
Can be for such index not to produce compression?