INDEX BY TABLE 关联数组
But be careful with this tactic; you do not want to replicate a table in an index by including all of the table's columns in the index key.
但是要小心使用这一策略;您并不想以在索引键中包含数据表所有列的方式在索引中复制一个表。
An index only scan is an index access that is not followed by a table access because the index itself contains all the requested data.
仅扫描索引是未包含表访问的索引访问,因为索引本身包含了所有被请求的数据。
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.
优化器的操作基于数据表中的行数、数据表或索引使用的空间以及其他信息的相关统计数据。
应用推荐