发明名称 |
DYNAMICALLY ADJUSTING STATISTICS COLLECTION TIME IN A DATABASE MANAGEMENT SYSTEM |
摘要 |
Each of one or more commit cycles may be associated with a predicted number of updates. A statistics collection time for a database table can be determined by estimating a sum of predicted updates included in one or more commit cycles. Whether the estimated sum of predicted updates is greater than a first threshold may be determined. In addition, a progress point for a first one of the commit cycles can be determined. A time to collect statistics may be selected based on the progress point of the first commit cycle. |
申请公布号 |
US2016292232(A1) |
申请公布日期 |
2016.10.06 |
申请号 |
US201514750074 |
申请日期 |
2015.06.25 |
申请人 |
International Business Machines Corporation |
发明人 |
Konik Rafal P.;Mittelstadt Roger A.;Muras Brian R.;Olstad Chad A. |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
1. A computer-implemented method for determining a statistics collection time for a database table, 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; and selecting a time to collect statistics based on the progress point of the first commit cycle. |
地址 |
Armonk NY US |