Database statistics based on transaction state
AssigneeInternational Business Machines Corporation
InventorsRafal P. Konik, Roger A. Mittelstadt, Brian R. Muras, Chad A. Olstad
Life of this patent
Estimating the term…
Abstract
A computer-implemented method for determining a query execution plan based on transaction state may include determining that a first set of database values in a database table are in a committed transaction state and that a second set of database values in the database table are in an uncommitted transaction state. In response to the determining, the first set of database values may have a first set of statistics generated and the second set of database values may have a second set of statistics generated. The first and second set of statistics may be for use in determining a query execution plan.
Claims16
A computer-implemented method for determining a query execution plan based on transaction state, comprising:
- determining, by a transaction manager executing on a processor, that a first set of database values in a database table are in a committed transaction state and that a second set of database values in the database table are in an uncommitted transaction state;
- in response to the determining, generating, by a statistics manager executing on the processor, a first set of statistics for the first set of database values and generating a second set of statistics for the second set of database values, the first and second set of statistics for use in determining a query execution plan;
- and
- returning, using the query executing plan, one or more database records of interest.
A computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processor to cause the processor to perform a method for determining a query execution plan based on transaction state comprising:
- determining, by a transaction manager executing on a processor, that a first set of database values in a database table are in a committed transaction state and that a second set of database values in the database table are in an uncommitted transaction state;
- in response to the determining, generating, by a statistics manager executing on the processor, a first set of statistics for the first set of database values and generating a second set of statistics for the second set of database values, the first and second set of statistics for use in determining a query execution plan;
- and
- returning, using the query executing plan, one or more database records of interest.
Dependencies are inferred from the claim text.