| General Information |
| Description |
Gathers statistics for AW's DIMENSIONS & CUBES |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsawst.sql |
| First Available |
11.1 |
| Constants |
| Name |
Data Type |
Value |
|
aw_error
|
NUMBER |
-20001 |
|
| Dependencies |
|
DBMS_ASSERT
|
DBMS_AW_LIB |
DUAL |
|
| Object Privileges |
execute granted to PUBLIC |
| |
| ANALYZE |
This procedure generates optimizer statistics on a cube or a dimension |
dbms_aw_stats.analyze(inName IN
VARCHAR2); |
BEGIN
dbms_aw_stats.analyze('units_cube');
dbms_aw_stats.analyze('time');
dbms_aw_stats.analyze('customer');
dbms_aw_stats.analyze('product');
dbms_aw_stats.analyze('channel');
END;
/ |
