what is in 12c the best way to analyze tables and indexes for a schema in 12c?
Hi experts.
What is in 12c the best way to analyze tables and indexes for a schema in 12c?
I'am doing it this way, please tell me if this still the correct way or if I should change it to what.
execute dbms_stats.gather_schema_stats(ownname=>'DNC_ADMIN', DEGREE=> 5,CASCADE=>TRUE,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,method_opt => 'FOR ALL COLUMNS SIZE AUTO');