Help Center/ GaussDB(DWS)/ More Documents/ Developer Guide (Paris Region)/ Query Performance Optimization/ Query Improvement/ Reviewing and Modifying a Table Definition/ Using Partial Clustering
Updated on 2022-07-29 GMT+08:00
View PDF
Share

Using Partial Clustering

Partial Cluster Key is the column-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:

  1. 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.
  2. Select columns that are frequently selected (to filter much more undesired data) in simple expressions.
  3. List the less frequently selected columns on the top.
  4. List the columns of the enumerated type at the top.