首页>
外国专利>
Performing a multiple table join operating based on generated predicates from materialized results
Performing a multiple table join operating based on generated predicates from materialized results
展开▼
机译:根据物化结果生成的谓词执行多表联接操作
展开▼
页面导航
摘要
著录项
相似文献
摘要
An improved mechanism for processing a multiple table query includes: determining if any tables in the query require materialization; for each table in the query that requires materialization, deriving at least one join predicate on a join column; determining if any tables earlier in a join sequence for the query has same join predicates; and applying the at least one derived join predicate to an earlier table in the join sequence, if there is at least one table earlier in the join sequence that has the same join predicate. This significantly reduces the number of rows that are joined before arriving at the final result.
展开▼