For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi DBAs,
I am in learning phase and a newbie DBA. I got confused in gathering stats. Could someone elaborate on the below?:
ANALYZE TABLE employees COMPUTE STATISTICS;
and
DBMS_STATS.GATHER_TABLE_STATS ('hr', 'employees');