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