Transcription of The Optimizer in Oracle Database 19c
{{id}} {{{paragraph}}}
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.
INTRODUCTION The Oracle Optimizer is one of the most fascinating components of the Oracle Database, since it is ... 3 WHITE PAPER / The Optimizer in Oracle Database 19c TABLE OF CONTENTS ... (this is a data dictionary metadata change only) Verify
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}