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

Published by Admin

Amine HALLAM Talend Expert and Ex-Talend employee with 8 years experience with talend technologies,for more information please contact me here.

Leave a comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.