Database DataWarehousing (MOSC)

MOSC Banner

what is in 12c the best way to analyze tables and indexes for a schema in 12c?

edited Oct 10, 2014 10:24AM in Database DataWarehousing (MOSC) 6 commentsAnswered ✓

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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center