Dynamically adjusting statistics collection time in a database management system

A computer program product for determining a statistics collection time for a database table, the 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:

• estimate a sum of predicted updates included in one or more commit cycles, wherein each of the commit cycles is associated with a predicted number of updates, wherein the sum of predicted updates includes a probability that one or more commit cycles will be rolled back, and wherein the estimating the sum of predicted updates occurs before the end of phase one of the one or more commit cycles;
• determine whether the estimated sum of predicted updates is greater than a first threshold, and wherein the determining further includes a rollback threshold related to the probability that one or more commit cycles will be rolled back;
• determine a progress point for a first one of the commit cycles;
• and
• select a time to collect statistics based on the progress point of the first commit cycle, wherein the accuracy of the collected statistics is increased from collecting records from the database that were affected due to the probability that the commit cycle was rolled back in phase two of the commit cycle being greater than the rollback threshold.

A computing device for providing increased query performance in a database management system, the computing device comprising:

• a memory to store a database containing one or more tables of records and to store a database managements system for manipulation of the tables;
• a processor to perform database operations of the database management system comprising:
• estimating a sum of predicted updates included in one or more commit cycles, wherein each of the commit cycles is associated with a predicted number of updates;
• determining whether the estimated sum of predicted updates is greater than a first threshold;
• determining a progress point for a first one of the commit cycles;
• determining the age of the current set of statistics is greater than a staleness threshold;
• selecting a current time to collect statistics based on the progress point of the first commit cycle;
• and
• collecting, using sampling based on the selected current time and based on the determining the age is greater than the staleness threshold, statistics of a subset of data in the database.