First page Back Continue Last page Overview Graphics
Continuation of Notes
This is a full page of notes.
The slide is hidden.
Notes:
Run DBMS_STATS.GATHER_SCHEMA_STATS to collect stats for all of your tables and indexes. Limit histograms to just the indexed columns.
Hint: Use the CASCADE=>TRUE and METHOD_OPT=> parameters as shown in the example in this chapter.
Verify the creation of the statistics by running the following queries:
SELECT table_name
FROM user_tables
WHERE last_analyzed IS NULL;
SELECT index_name
FROM user_indexes
WHERE last_analyzed IS NULL;