索引设计对访问路径选择至关重要。
Index design has a critical impact on access path selection.
从而，它能提升可能的访问路径。
选择访问路径的其他影响因素。
描述访问路径最容易的方法是使用示例。
The easiest way to describe access paths is to use an example.
sql语句本身也会影响访问路径选择。
The SQL statement itself also impacts the access path selection.
它高效，因为索引适合于最佳访问路径的选择。
It is efficient, as the indexes qualify for the choice of excellent access paths.
选择访问路径：DB 2做出什么决策？为什么？
如图1所示，DB 2优化器选择最佳访问路径。
As shown in Figure 1, the DB2 optimizer chooses the best access path.
这些不同的方法就是众所周知的访问路径或访问计划。
These different ways are known as access paths or access plans.
访问路径显示在表cust_order_header上执行一个TBSCAN操作。
The access path shows that a TBSCAN operation is performed over the table CUST_ORDER_HEADER.
访问路径显示在表cust_order_header上执行一个TBSCAN操作。
The access path shows that a TBSCAN operation is performed over the table CUST_ORDER_HEADER.
应用推荐