Invention Grant
- Patent Title: Dynamically adjusting statistics collection time in a database management system
-
Application No.: US14672858Application Date: 2015-03-30
-
Publication No.: US10372578B2Publication Date: 2019-08-06
- Inventor: Rafal P. Konik , Roger A. Mittelstadt , Brian R. Muras , Chad A. Olstad
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Nolan M. Lawrence
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F11/30 ; G06F16/21 ; G06F16/23 ; G06F11/34 ; G06F16/2453

Abstract:
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.
Public/Granted literature
- US20160292190A1 DYNAMICALLY ADJUSTING STATISTICS COLLECTION TIME IN A DATABASE MANAGEMENT SYSTEM Public/Granted day:2016-10-06
Information query