Patent ID: 6466931
Filing Date: 2002-10-15
Classification: G06F,Y10S

Abstract:
A method for transparently caching and reusing database query execution plans, the method comprising the steps of:(a) caching a first query that contains a first constant, wherein a first query execution plan has been generated for the first query that represents the fist constant with a parameter name; (b) receiving a new query that contains a second constant; (c) generating signatures for the new query and the first query; (d) if the signatures match, comparing the new query with the first query and determining that a match exists even when the second constant fails to match the first constant; and (e) upon a match, reusing the first query execution plan by substituting the parameter name in the first query execution plan with the second constant from the new query, thereby avoiding generating a new query execution plan for the new query.