发明名称 JOIN ORDER RESTRICTIONS
摘要 A query that is submitted to a database is analyzed so as to determine a join order restriction. The join order restriction is associated with a join between two tables of a plurality of tables of the database that participate in the query. The join order restriction constrains its associated join to be executed prior to another join of the query. At least one join plan is generated, the join plan being constrained by the join order restriction. Different join plans include different join orders. A join plan is selected from among the join plans for execution of the query.
申请公布号 US2012290559(A1) 申请公布日期 2012.11.15
申请号 US201213469641 申请日期 2012.05.11
申请人 FULLER MATTHEW STEVEN;LAMB ANDREW ALLINSON;SHRINIVAS LAKSHMIKANT 发明人 FULLER MATTHEW STEVEN;LAMB ANDREW ALLINSON;SHRINIVAS LAKSHMIKANT
分类号 G06F17/30 主分类号 G06F17/30
代理机构 代理人
主权项
地址