Help Center > > Developer Guide> Excellent Practices> Excellent Practices for Table Design> Learning the Tutorial: Tuning Table Design

Learning the Tutorial: Tuning Table Design

Updated at: Mar 13, 2020 GMT+08:00

During database design, some key factors about table design will greatly affect the subsequent query performance of the database. Table design affects data storage as well. Scientific table design reduces I/O operations and minimizes memory usage, improving the query performance.

Overview describes how to select the sequence keys, distribution modes, and compression encoding for tables, and how to compare system performance before and after tuning.

The following sections summarize the key points associated with table design and provide suggestions for excellent practices.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?

Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel