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 best practices.