• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Best Practices
  5. Best Practices of Table Design
  6. Selecting a Storage Model

Selecting a Storage Model

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.

Selecting a model for table storage is the first step of table definition. Customer service attribute is a key factor of table storage model. You can select a proper storage model for the current service based on the following table.

Storage Model

Application Scenario

Row storage

Point queries (simple index-based queries that only return a few records).

In this scenario, operations, such as adding, modifying, and deleting are performed many times.

Column storage

Statistics analysis query, in which operations, such as group and join, are performed many times.