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. This paper introduces all of the new Optimizer and statistics related features in Oracle Database 19c and provides simple, reproducible examples to make it easier to get acquainted with them, especially when migrating from previous versions. It also outlines how existing functionality has been enhanced to improve both performance and manageability. To get a complete picture of the Oracle Optimizer , it is recommended that you read this paper in conjunction with the relevant papers listed in the References section.

Your access to and use of this confidential material is subject to the ... discover additional information that can lead to better statistics. This new approach is extremely helpful when existing statistics are not ... significant difference, then the plan or a portion of it will be automatically adapted to avoid suboptimal performance.

Tags:

  Oracle, Database, Your, Differences, Discover, Optimizers, The optimizer in oracle database 19c

Information

Related search queries