Help Center/ GaussDB/ Developer Guide(Centralized_2.x)/ Best Practices/ Best Practices of Table Design/ Using Partial Cluster Keys (PCKs)

Updated on 2023-10-23 GMT+08:00

View PDF

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.

Parent topic: Best Practices of Table Design

Previous topic: Selecting a Storage Model

Next topic: Using Partitioned Tables

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.