The DB2 9.5 optimizer USES both type of indexes to optimize the queries and help selecting the best plan for query execution.
DB 2 9.5优化器使用两种类型的索引来优化查询,并帮助选择最佳的查询执行计划。
Make sure appropriate indexes are used to minimize the rows that have to be fetched internally when selecting and joining tables.
请确保使用合适的索引,从而在选择和连接(join)表时,将必须在内部访存的行数减到最少。
The Indexes view allows you to create indexes for the table by selecting from the list of columns defined for the table.
Indexes 视图允许通过从为表定义的列列表中作出选择来创建索引。
应用推荐