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

Storage Model

Application Scenario

Row storage

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

Scenarios requiring frequent addition, deletion, and modification operations

Column storage

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

编组 3备份
    openGauss 2024-07-19 01:03:13