Oracle : Execute stats on oracle table

Oracle : Execute stats on oracle table

EXEC DBMS_STATS.gather_table_stats(USER,’MYTABLE’, cascade=>true,estimate_percent=>50);

or with parrallelisation

EXEC DBMS_STATS.gather_table_stats(USER,’MYTABLE’, cascade=>true,estimate_percent=>50,degree=>4);

Leave a Reply