Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The SPARSITY_ADVICE_TABLE
procedure creates a table for storing the advice generated by the ADVISE_SPARSITY
procedure.
Note:
You cannot execute this procedure from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL*Plus.See also:
"Using the Sparsity Advisor"SPARSITY_ADVICE_TABLE ( tblname IN VARCHAR2 DEFAULT);
Table B-30 SPARSITY_ADVICE_TABLE Procedure Parameters
Parameter | Description |
---|---|
|
The name of the table. The default name is |
The following example creates a table named GLOBAL_SPARSITY_ADVICE
.
EXECUTE dbms_aw.sparsity_advice_table('global_sparsity_advice');