表分析语句
analyTab.sql
SELECT 'ANALYZE TABLE '||TABLE_NAME||' COMPUTE STATISTICS ;'
FROM USER_TABLES;
-----------------------------------------------------------------------------------------
表索引分析语句
analyIdx.sql
SELECT 'ANALYZE TABLE '||TABLE_NAME||' COMPUTE STATISTICS
FOR ALL INDEXES;' FROM USER_TABLES;