Updated on 2023-10-23 GMT+08:00

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.