Best Practices for Gathering Optimizer Statistics ... - Oracle

Best Practices for Gathering Optimizer Statistics with Oracle database 12c Release 2 O R A C L E W H I T E P A P E R | J U N E 2 0 1 7 BEST Practices FOR Gathering Optimizer Statistics with Oracle database 12C RELEASE 2 Table of Contents Introduction 1 How to Gather Statistics 1 When to Gather Statistics 7 Assuring the Quality of Optimizer Statistics 11 Gathering Statistics More Quickly 13 When Not to Gather Statistics 16 Gathering Other Types of Statistics 18 Conclusion 20 References 21 1 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.

The part one of this series, Understanding Optimizer Statistics with Oracle Database 12c, focuses on the concepts of statistics and will be referenced several times in this paper as a source of additional information. This paper will discuss in detail, when and how to gather statistics for the most common scenarios seen in an Oracle Database ...

Loading..

Tags:

  Oracle, Database, With, Practices, Understanding, Statistics, Optimizers, Oracle database, Gathering, Understanding optimizer statistics with oracle database, Practices for gathering optimizer statistics

Information

Related search queries