US 2006/0218129 A1 · Dynamic look ahead predicate generation

Abstract

An apparatus, program product and method that employ a dynamic use of Look Ahead Predicate Generation that will enable the database, database engine, and/or query optimizer to alter the processing of a query, and react to sub-optimal access plan selection and additional factors arising after processing has begun, to heal many poor performing queries. Conventional use of LPG requires the query optimizer to decide whether or not to use LPG before the processing of a query begins. As a result, the query optimizer may not only make sub-optimal decisions, but the query optimizer may not consider additional factors that may arise as the query is processing. However, the dynamic use of LPG allows predicates to be built after processing of the query has started and the ability to alter the query's processing to improve query performance.

Claims23

Dependent claims

A method for optimizing a database query with look ahead predicate generation, the method comprising:

(a) initiating processing of a database query, including fetching at least one record from the database based upon the database query;
(b) performing look ahead predicate generation for the database query after processing of the database query has been initiated and at least one record has been fetched from the database;
and
(c) fetching a least one additional record from the database based upon the database query using results of the look ahead predicate generation.

1 more element

Dependencies are inferred from the claim text.

Dynamic look ahead predicate generation

Life of this patent

Dynamic look ahead predicate generation

Life of this patent

Abstract

Claims23