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:

"Using the Sparsity Advisor"

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 GLOBAL_SPARSITY_ADVICE.

EXECUTE dbms_aw.sparsity_advice_table('global_sparsity_advice');