Using Partial Cluster Keys (PCKs)
PCK is a column-store technology. It can minimize or maximize sparse indexes to quickly filter base tables. PCKs can be used to specify multiple columns. However, it is recommended that a maximum of two columns be specified. Use the following principles to specify PCKs:
- The specified PCKs must be restricted by simple expressions in base tables. Such constraints are usually represented by col op const, in which col indicates the column name, op indicates operators (including =, >, >=, <=, and <), and const indicates constants.
- Select columns that are frequently selected (to filter much more undesired data) in simple expressions.
- List the most frequently selected columns at the top.
- List the columns of the enumerated type at the top.
Feedback