We are currently migrating to 10.2.0.3 enterprise ( from 8i ) by
1) datpumping schema
2) Running histogram scripts
eg DBMS_STATS.GATHER_TABLE_STATS ('LIVCACHE','MI_BATCH',METHOD_OPT=>'
FOR COLUMNS BATCH_NO SIZE 75');
3) Gathering stats on all by using method_opt FOR ALL COLUMNS SIZE
REPEAT
When I check for histograms afterwards I find that step 3 has created
new histograms ...whereas I thought this option would only build a
histogram if one already existed / Can anyone advise if my expectation
of the result is flawed and if so why?
Received on Mon Nov 12 2007 - 11:08:51 CST
