Invention Grant
- Patent Title: Online optimizer statistics maintenance during load
-
Application No.: US16147511Application Date: 2018-09-28
-
Publication No.: US11113282B2Publication Date: 2021-09-07
- Inventor: Sunil P. Chakkappen , Hong Su , Mohamed Zait , Suratna Budalakoti
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Becker Bingham Ledesma LLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453 ; G06F7/14 ; G06F16/22 ; G06F16/23 ; G06F16/951 ; G06F16/2458

Abstract:
Techniques are provided for merging (a) statistics associated with data added to a table in a bulk load operation with (b) statistics associated with data that existed in the table before the bulk load operation. The statistics associated with the bulk load data are generated on-the-fly during the bulk load, and are merged with the pre-existing statistics as part of the same transaction that is used to perform the bulk load operation. Consequently, execution plans for queries that are assigned snapshot times after the commit time of the bulk load transaction will be selected based on the new statistics, while execution plans for queries that are assigned snapshot times before the commit time of the bulk load transaction will be selected based on the pre-existing statistics.
Public/Granted literature
- US20190102427A1 ONLINE OPTIMIZER STATISTICS MAINTENANCE DURING LOAD Public/Granted day:2019-04-04
Information query