Database Reference
In-Depth Information
Table 8-8. Parameters of the Procedures Used for Deleting Object Statistics
Parameter
Database
Dictionary
Fixed Objects
Schema
Table
Column
Index
Target Objects
ownname
indname
tabname
colname
partname
cascade_parts
cascade_columns
cascade_indexes
stat_category
col_stat_type
force
Deleting Options
no_invalidate
Backup Table
stattab
statid
statown
The following call shows how to delete the histogram of one single column (a full example is found in the
delete_histogram.sql script) without modifying the other statistics:
dbms_stats.delete_column_stats(ownname => user,
tabname => 'T',
colname => 'VAL',
col_stat_type => 'HISTOGRAM')
Exporting, Importing, Getting, and Setting Object Statistics
As illustrated earlier in Figure 8-1 , the dbms_stats package provides several procedures and functions that are
available in addition to those used for gathering statistics. I won't describe them here because they're not frequently
used in practice. For information about them, refer to the Oracle Database PL/SQL Packages and Types Reference
manual. Nevertheless, I want to share the following piece of information that you don't find in the documentation.
 
 
Search WWH ::




Custom Search