Invention Grant
- Patent Title: Database statistics based on transaction state
-
Application No.: US14751237Application Date: 2015-06-26
-
Publication No.: US10025821B2Publication Date: 2018-07-17
- 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 James L. Olsen
- Main IPC: G06F17/30
- IPC: G06F17/30

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
- US20160299949A1 DATABASE STATISTICS BASED ON TRANSACTION STATE Public/Granted day:2016-10-13
Information query