Why use CASCADE=>'TRUE' for DBMS_STATS.GATHER_SCHEMA_STATS('HR') ?
hi,
Why use CASCADE=>'TRUE' when using
exec DBMS_STATS.GATHER_SCHEMA_STATS('HR')
the above will gather the statistics of all objects under HR schema, including indexes that belong to HR schema.
So below CASCADE=>TRUE is pointless, unless I have indexes in a different schema I guess (?)
exec DBMS_STATS.GATHER_SCHEMA_STATS('HR', CASCADE => TRUE)
Link to documentation where I read this
in documentation see
GATHER_SCHEMA_STATS Procedures description
This procedure gathers statistics