Other considerations for access path selection.
选择访问路径的其他影响因素。
Index design has a critical impact on access path selection.
索引设计对访问路径选择至关重要。
The SQL statement itself also impacts the access path selection.
sql语句本身也会影响访问路径选择。
As shown in Figure 1, the DB2 optimizer chooses the best access path.
如图1所示,DB 2优化器选择最佳访问路径。
The access path shows that a TBSCAN operation is performed over the table CUST_ORDER_HEADER.
访问路径显示在表cust_order_header上执行一个TBSCAN操作。
Access path selection: What did DB2 decide, and why?
选择访问路径:DB 2做出什么决策?为什么?
Access path selection: What did DB2 decide, and why?
选择访问路径:DB 2做出什么决策?为什么?
应用推荐