Transcription of Best Practices for Gathering Optimizer Statistics ... - Oracle
{{id}} {{{paragraph}}}
Example: biology
Best Practices for Gathering Optimizer Statistics ... - Oracle
best Practices for Gathering Optimizer Statistics with Oracle database 19c Oracle W HITE PAPER / DECEMBER 9, 2019. INTRODUCTION. The Oracle Optimizer examines all of the possible plans for a SQL statement and picks the one with the lowest cost, where cost represents the estimated resource usage for a given plan. In order for the Optimizer to accurately determine the cost for an execution plan it must have information about all of the objects (table and indexes) accessed in the SQL statement as well as information about the system on which the SQL statement will be run.
2 WHITE PAPER / Best Practices for Gathering Optimizer Statistics with Oracle Database 19c INTRODUCTION The Oracle Optimizer examines all of the possible plans for a SQL statement and picks the one with the lowest cost, where cost represents the estimated resource usage for a given plan.
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: