Open AccessImpact of Data Statistics on the Execution Plan of the Oracle Database
Author(s) -
Aiwu Li
Publication year - 2020
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/1650/3/032094
Subject(s) - computer science , database , oracle , oracle database , column (typography) , plan (archaeology) , table (database) , summary statistics , physical data model , view , information retrieval , data mining , statistics , database design , database testing , mathematics , programming language , geography , telecommunications , archaeology , frame (networking)
The data in the database is constantly changing. In order to make the statistical information truly reflect the current situation of the database, it is necessary to update the statistical information when needed. This paper uses column statistics as an example to analyze the impact of statistics on the execution plan of a single-table query.