Overview

To properly define a table, you must:

  1. Reduce the data volume scanned by using the partition pruning mechanism.
  2. Minimize random I/Os by using clustering or partial clustering.

The table definition is created during the database design and is reviewed and modified during the SQL statement optimization.

Feedback
编组 3备份
    openGauss 2024-05-29 00:44:48
    cancel