The ANALYZE_PART_OBJECT procedure provides the capability
to gather statistics on a partitioned table or index.
Syntax
>>-DBMS_UTILITY.ANALYZE_PART_OBJECT--(--schema--,--object_name-->
>--+-------------------------------------------------------------------------------+-->
'-,--object_type--+-----------------------------------------------------------+-'
'-,--command_type--+--------------------------------------+-'
'-,--command_opt--+------------------+-'
'-,--sample_clause-'
>--)-----------------------------------------------------------><
Parameters
- schema
- An input argument of type VARCHAR(128) that specifies the schema
name of the schema whose objects are to be analyzed.
- object_name
- An input argument of type VARCHAR(128) that specifies the name
of the partitioned object to be analyzed.
- object_type
- An optional input argument of type CHAR that specifies the type
of object to be analyzed. Valid values are:
The default is T.
- command_type
- An optional input argument of type CHAR that specifies the type
of analyze functionality to perform. Valid values are:
- E - gather estimated statistics based upon on a specified number
of rows or a percentage of rows in the sample_clause clause;
- C - compute exact statistics; or
- V - validate the structure and integrity of the partitions.
The default value is E.
- command_opt
- An optional input argument of type VARCHAR(1024) that specifies
the options for the statistics calculation. For command_type E
or C, this argument can be any combination of:
- [ FOR TABLE ]
- [ FOR ALL COLUMNS ]
- [ FOR ALL LOCAL INDEXES ]
For command_type V, this argument can be CASCADE
if object_type is T. The default value is NULL.
- sample_clause
- An optional input argument of type VARCHAR(128). If command_type is
E, this argument contains the following clause to specify the number
of rows or percentage of rows on which to base the estimate.
SAMPLE n { ROWS | PERCENT }
The default value is SAMPLE 5 PERCENT.
Authorization
EXECUTE privilege on the DBMS_UTILITY
module.
DB2 10.5 for Linux, UNIX, and Windows