ETL_STATS_CASCADE_OPTION

Parameters Values

Section

Database

Key

ETL_STATS_CASCADE_OPTION

Default Value

TRUE (Statistics should be gathered for all indexes on the table currently being analyzed)

Description

This switch is used to define CASCADE parameter for DBMS_STATS, while gathering statistics of Stage and Mart Schema.