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. A good 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. Select a proper storage model for your service based on the following table:

Storage Model	Applicable Scenario
Row-store	Point queries (simple index-based queries that only return a few records) Scenarios requiring frequent addition, deletion, and modification operations
Column-store	Statistics analysis query, in which operations, such as group and join, are performed many times.

Storage Model

Applicable Scenario

Row-store

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

Scenarios requiring frequent addition, deletion, and modification operations

Column-store

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

Parent topic: Best Practices of Table Design

Previous topic: Best Practices of Table Design

Next topic: Using Partial Cluster Keys (PCKs)