PREPARED EXECUTION PLANS FOR JOINS WITH PARTITIONED TABLES

摘要

A computer-implemented method for preparing and executing a plan for a query containing joins against one or more tables having multiple partitions includes receiving a query containing joins to execute against one or more tables in a database, where at least one of the tables includes multiple partitions. Prior to executing the query, the method includes preparing a plan to join the multiple partitions using paths between the joined partitions and storing the plan in a cache. During execution of the query, the method includes analyzing one or more clauses of the query to determine which of the joined partitions to prune from the plan, removing from the plan the paths connecting the pruned partitions and executing the plan without the pruned partitions to return a result to the query.

主权项

1. A computer-implemented method for preparing and executing a plan for a query containing joins against one or more tables having multiple partitions, the method comprising:
receiving a query containing joins to execute against one or more tables in a database, wherein at least one of the tables includes multiple partitions; prior to executing the query, preparing a plan to join the multiple partitions using paths between the joined partitions; storing the plan in a cache; during execution of the query, analyzing one or more clauses of the query to determine which of the joined partitions to prune from the plan; removing from the plan the paths connecting the pruned partitions; and executing the plan without the pruned partitions to return a result to the query.