SPARSITY_ADVICE_TABLE Procedure

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:

Syntax

SPARSITY_ADVICE_TABLE (
          tblname   IN    VARCHAR2 DEFAULT);

Parameters

Table B-30 SPARSITY_ADVICE_TABLE Procedure Parameters

Parameter	Description
`tblname`	The name of the table. The default name is `AW_SPARSITY_ADVICE`, which is created in your own schema. See ADVISE_SPARSITY Procedure for a description of the columns in tblname.

Example

The following example creates a table named MYAW_SPARSITY_ADVICE.

execute dbms_aw.sparsity_advice_table('myaw_sparsity_advice');