Impact of Data Statistics on the Execution Plan of the Oracle Database
Aiwu Li · Journal of Physics Conference Series · 2020
Abstract 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.