Gather Statistics on Oracle 11g

Schema Statistics:

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('USERNAME',DBMS_STATS.AUTO_SAMPLE_SIZE);

Table Statistics:

EXEC DBMS_STATS.gather_table_stats('SCOTT', 'EMP'); 

Index Statistics:


EXEC DBMS_STATS.gather_index_stats('SCOTT', 'EMPLOYEES_PK');