1. A method for optimizing a database query with look ahead predicate generation, the method comprising: (a) initiating processing of a database query on a computer that includes a processor and a memory, including fetching at least one record from a 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, wherein performing look ahead predicate generation generates at least one additional predicate to the database query; 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. A method for optimizing a database query with look ahead predicate generation, the method comprising: (a) initiating processing of a database query on a computer that includes a processor and a memory, including fetching at least one record from a 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, wherein performing look ahead predicate generation generates at least one additional predicate to the database query; and (c) fetching a least one additional record from the database based upon the database query using results of the look ahead predicate generation. 4. The method of claim 1 , further comprising determining to perform look ahead predicate generation based upon a threshold.