If specified, it can only take the value 'TRUE' to indicate that the given table must be the first table accessed in a join query.
如果指定了的话,它将只接受“TRUE”值,表示给定表必须是连接查询中进行访问的第一个表。
A star join query typically involves a fact table and several dimension tables, with join predicates between the fact table and each dimension table.
一个星型连接查询通常包含一个事实表和几个维度表,事实表和每个维度表之间都有连接谓词。
The optimizer considers star join optimization when appropriate and decides on star join plan based on cost considerations in order to come up with best execution plan for a star join query.
为了实现星型连接查询的最佳执行计划,优化器在适当的时候会考虑星型连接优化,并根据成本因素来决定星型连接计划。
Multiway spatial join is the spatial join query which concern several spatial relations.
空间多路连接是涉及多个空间关系的连接查询。
The multi-join query optimization is the critical problem of parallel query optimization in parallel database system.
多连接查询优化是并行数据库系统的核心问题。
Now most of the research work is based on the storage of single relation, and could not support effectively complex multi-join query.
已有的研究工作多集中在基于单个关系的存储分布,不能有效支持复杂多连接查询处理。
Multi-Join Query Optimization;
多连接查询优化;
The output of our disconnected JoinRowSet object correctly parallels the data we obtained when we performed our server side database JOIN query (compare to Table 3).
非连接对象JoinRowSet的输出与我们在服务器端执行join查询得到的数据完全一致(与表3比较)。
Example 5: INLIST to Nested Loop Join (query rewrite).
例子5:INLIST改为嵌套循环连接(查询重写)。
Example 5: INLIST to Nested Loop Join (query rewrite).
例子5:INLIST改为嵌套循环连接(查询重写)。
应用推荐