Help Center> Data Warehouse Service> Best Practices> Excellent Practices for Table Design> Learning the Tutorial: Tuning Table Design
Learning the Tutorial: Tuning Table Design
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.
Parent topic: Excellent Practices for Table Design
Last Article: Excellent Practices for Table Design
Next Article: Selecting a Storage Model
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.