紧凑的数据表可以针对基于行的数据库做存储块优化,让SQL执行得更好。
Compact tables can optimize storage blocks for row-based databases and accordingly make SQL perform better.
优化器的操作基于数据表中的行数、数据表或索引使用的空间以及其他信息的相关统计数据。
The optimizer ACTS based on statistical data about the number of rows in a table, the use of space by a table or index, and other information.
垂直分区是一种以垂直方式分割数据表结构的优化方法。
Vertical Partitioning is the act of splitting your table structure in a vertical manner for optimization reasons.
应用推荐