Access path selection: What did DB2 decide, and why?

选择访问路径：DB 2做出什么决策？为什么？

youdao

Before access path selection, the DB2 optimizer transforms SQL statements into forms that are semantically identical, such as by using predicate pushdown or predicate transitive closure.

在选择访问路径之前，DB 2优化器将sql语句转换成语意上一致的形式，例如使用谓词下推或谓词传递闭包。

youdao

The SQL statement itself also impacts the access path selection.

sql语句本身也会影响访问路径选择。

youdao

He will then visit 21 different locations along the coast path with a smaller selection of paintings.

BBC: England