Les06-状态收集.pptVIP

Gathering Statistics Objectives After completing this lesson, you should be able to do the following: Use the DBMS_STATS package Identify table, index, and column statistics Identify predicate selectivity calculations Create histograms for columns with skewed data What Are Statistics? Information used by cost-based optimization: To estimate the selectivity of predicates To estimate the cost of each execution plan To estimate the number of table rows To estimate CPU and I/O costs Types of Statistics Object statistics Table statistics Column statistics Index statistics System statistics I/O