Patent ID: 7490110
Filing Date: 2009-02-10
Classification: G06F,Y10S

Abstract:
1. A computer program product for query execution through materialization of intermediate results, the computer program product comprising: a computer usable medium having computer usable program code tangibly embodied thereon, the computer usable program code comprising: computer usable program code for identifying a set of sub-plans of a query execution plan prior to execution of the query execution plan, wherein each sub-plan of the set of sub-plans comprises a portion of the query execution plan for which an intermediate result of the sub-plan does not depend on other parts of the query execution plan that have not already been executed; computer usable program code for computing the set of sub-plans prior to execution of the query execution plan and prior to the computation of the other parts of the query execution plan, wherein computing the set of sub-plans comprises: computer usable program code for optimizing the query execution plan for cost using the useable materialized computed intermediate results to form an optimized query execution plan.