Greg Low talks though and generously shares in his blog the script he uses to determine which compression strategy to use on tables. As part of that the cutoff points are configurable but his default values are as shown:
CCI (Clustered Columnstore Index) will be recommended where the partition is scanned more than 95% of the time, updated less than 10% of the time, seeks and lookups are less than 5% of the time, and where there are at least 800,000 rows. It will also only be recommended if it is supported.
PAGE will be recommended where the partition is scanned more than 75% of the time and updated less than 20% of the time.
ROW will be recommended in all other cases. We believe that ROW should be the default in SQL Server across the board, instead of NONE.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.