Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-2.x)/ SQL Optimization/ Reviewing and Modifying a Table Definition/ Overview
Updated on 2025-08-19 GMT+08:00
Overview
To properly define a table, you must:
- Reduce the data volume scanned by using the partition pruning mechanism.
- 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.
Parent topic: Reviewing and Modifying a Table Definition
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
