Analyzing Database Objects and Managing Indexes

This section describes the options used to update statistics about the physical characteristics of a table and the associated indexes. These characteristics include number of records, number of pages, and average record length. The optimizer uses these statistics when determining access paths to the data. You can use these options to analyze database objects, create, and drop indexes. The topics covered are:

 Update Statistics
Drop Indexes
Create Indexes