Transcription of The Optimizer in Oracle Database 19c
{{id}} {{{paragraph}}}
Example: confidence
The Optimizer in Oracle Database 19c
The Optimizer In Oracle Database 19c Oracle W HITE PAPER / MARCH 13, 2019 2 W HIT E PA PER / The Optimizer in Oracle Database 19c INTRODUCTION The Oracle Optimizer is one of the most fascinating components of the Oracle Database , since it is essential to the processing of every SQL statement. The Optimizer determines the most efficient execution plan for each SQL statement based on the structure of the given query, the available statistical information about the underlying objects, and all the relevant Optimizer and execution features.
Check the Oracle Database Licensing Guide for more information. ... 9 WHITE PAPER / The Optimizer in Oracle Database 19c During the initial execution, the statistics collector gathers information about the execution and buffers a portion of rows coming into the sub-plan. The Optimizer determines what statistics are to be collected, and how the ...
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: