Thus, the way you write the XMLEXISTS predicate can affect the join order in these previous versions of DB2.
因此,编写xmlexists谓词的方式可以影响以前的DB 2版本连接顺序。
The optimizer can use its knowledge of the appliance components to determine the best join order in a complex join.
优化器可以利用其有关设备组件的知识,确定复杂联接操作中的最佳联接顺序。
Relational guidelines such as join, MSJOIN, NLJOIN, and HSJOIN can be used to specify the join order and the join type.
关系准则,比如join、MSJOIN、NLJOIN和HSJOIN都可以用来指定连接顺序和连接类型。
应用推荐