Influencing join orders and join methods in XML queries.
影响XML查询中的连接顺序和连接方法。
Cardinality affects join orders and join methods to a large extent.
这个基数会大大影响连接顺序和连接方法。
This section covers a few more access methods, join methods, and sort operations.
本部分涵盖了更多的访问方法、联接方法和排序操作。
The most commonly used join methods are nested-loop join, sort merge join and dynamic hash join.
最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。
An access plan defines the order for accessing tables, which indexes are used, and by what kind of join methods data is correlated.
访问计划定义按什么顺序访问表,使用哪些索引,以及用何种连接(join)方法来关联数据。
The optimization of SQL queries utilize sophisticated features, such as: query rewrite, multiple join methods, detailed statistics, parallelism etc.
SQL查询的优化利用了一些复杂的功能,例如:查询重写、多连接(join)方法、详细的统计、并行性等。
Now that you have an overview of the tables and how the information is accessed (via indexes in this case), you are ready take a closer look at the join methods that are used.
现在您有了一个关于表和如何访问信息(在这种情况下通过索引)的概述,您已准备好仔细查看正在使用的联接方法。
Now that you have an overview of the tables and how the information is accessed (via indexes in this case), you are ready take a closer look at the join methods that are used.
现在您有了一个关于表和如何访问信息(在这种情况下通过索引)的概述,您已准备好仔细查看正在使用的联接方法。
应用推荐