On this page

Show all

Table Optimization Overview

Updated on 2024-03-13 GMT+08:00

In this practice, you will learn how to optimize the design of your tables. You will start by creating tables without specifying their storage mode, distribution key, distribution mode, or compression mode. Load test data into these tables and test system performance. Then, follow excellent practices to create the tables again using new storage modes, distribution keys, distribution modes, and compression modes. Load the test data and test performance again. Compare the two test results to find out how table design affects the storage space, and the loading and query performance of the tables.

Estimated time: 60 minutes

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback