Advertisement

Object Statistics

  • Tony Hasler
Chapter

Abstract

Although the CBO makes its decisions about how to optimize a statement using data from various sources, the majority of the important information the CBO needs comes from object statistics. Most of this chapter is dedicated to an explanation of object statistics, although we will conclude this chapter with a few short points about other sources of information that the CBO uses.

Keywords

Object Statistic Global Statistic Extended Statistic Execution Plan Data Dictionary 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Tony Hasler 2014

Authors and Affiliations

  • Tony Hasler
    • 1
  1. 1.BurntislandUnited Kingdom

Personalised recommendations