紧凑的数据表可以针对基于行的数据库做存储块优化,让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.
停机时间将可能比以往的更长,因为除了备份数据库以及优化数据表,我们还要将项目文件移动至文件服务器上。
Today's down time is expected to be a bit longer than usual because, in addition to backing up our database and optimizing tables, we are also going to move our project files over to the file server.
停机时间将可能比以往的更长,因为除了备份数据库以及优化数据表,我们还要将项目文件移动至文件服务器上。
Today's down time is expected to be a bit longer than usual because, in addition to backing up our database and optimizing tables, we are also going to move our project files over to the file server.
应用推荐