How gather schema stats work?
Hi Friends,
I have a question.
cat gather_schema_stats.sql
exec dbms_stats.GATHER_SCHEMA_STATS ('ADM', CASCADE=>TRUE);
exec dbms_stats.GATHER_TABLE_STATS (ownname=>'ADM',tabname =>'TIME');
exec dbms_stats.GATHER_TABLE_STATS (ownname=>'ADM',tabname =>'TIME_WRK');
exec dbms_stats.GATHER_TABLE_STATS (ownname=>'ADM',tabname =>'CS_POLL');
If I execute the above script, it will gather statistics for the ADM schema first. Then, will it gather statistics again for the tables or will it NOT? Those tables belong to the same schema ADM. Please clarify my doubt.
Thanks and Regards,
Su.