Estimate statistics for oracle subpartitions
                                                 Last update (2011-05-15 00:10:50)
                                                                                                                   Date added (2010-07-07 08:39:18)

Summary
You can create sql statements for subpartition statistics with the following query
SELECT 'execute DBMS_STATS.GATHER_TABLE_STATS(ownname=> ' || '''' 
|| table_owner || '''' || ', tabname=> ' || '''' || table_name || 
'''' || ', partname=> ' || '''' || partition_name || '''' 
|| ', estimate_percent=>1, granularity=> ' || '''' || 
'ALL' || '''' || ', DEGREE=>20, CASCADE=>TRUE);' SQL 
FROM dba_tab_partitions 
WHERE table_name = 'CLI_MON_SNP' 
AND table_owner = 'TARGET_DW' 
ORDER BY partition_position;
You must execute the output of the script
Reviews
Filters
Search