First page Back Continue Last page Overview Graphics

Workshop

DBMS_STATS

Notes:

DBMS_STATS Workshop

Run the following command to delete all table and index statistics in your schema:
EXECUTE DBMS_STATS.DELETE_SCHEMA_STATS ('DAVE');
Run the following command:
EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS ('DAVE');
Did the command in question 2 create index statistics? Run this command to found out:
SELECT index_name
FROM user_indexes
WHERE last_analyzed IS NULL;

Workshop continues on the next page…