Snippet Name: List analyzed tables with un-analyzed indexes
Description: Sometimes indexes are re-build for performance and maintenance reasons but the associated table/index is not re-ANALYZED. This can cause severe performance problems. This script will catch out tables with indexes that is not analyzed.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 02nd, 2009
-- select distinct 'analyze table '||i.table_name||-- ' estimate statistics sample 25 percent;'SELECT'Index '||i.index_name||' not analyzed but table '||
i.table_name||' is.'FROM user_tables t, user_indexes i
WHERE t.table_name = i.table_name
AND t.num_rows ISNOTNULLAND i.distinct_keys ISNULL/
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.