Invention Grant
- Patent Title: Database statistics based on transaction state
-
Application No.: US15244848Application Date: 2016-08-23
-
Publication No.: US09697251B2Publication Date: 2017-07-04
- 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 Joseph W. Cruz
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F7/00

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.
Public/Granted literature
- US20160350373A1 DATABASE STATISTICS BASED ON TRANSACTION STATE Public/Granted day:2016-12-01
Information query