Help Center> Data Warehouse Service> Best Practices> Excellent Practices for Table Design> Using Partial Clustering
Using Partial Clustering
Partial Cluster Key is the column-store-based technology. It can minimize or maximize sparse indexes to quickly filter base tables. Partial cluster key can specify multiple columns, but you are advised to specify no more than two columns. Use the following principles to specify columns:
- The selected columns must be restricted by simple expressions in base tables. Such constraints are usually represented by Col, Op, and Const. Col specifies the column name, Op specifies operators, (including =, >, >=, <=, and <) Const specifies constants.
- Select columns that are frequently selected (to filter much more undesired data) in simple expressions.
- List the less frequently selected columns following Col listed on the top.
- List the columns of the enumerated type at the top.
Parent topic: Excellent Practices for Table Design
Last Article: Using Partitioned Tables
Next Article: Selecting a Data Type
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.