copy_table_stats vs gather_table_stats vs Analyze
551398Jul 6 2011 — edited Jul 7 2011I have one samll question i know it could be silly or not, here it goes
-------------------------
DBMS_STATS.copy_table_stats (ownname => 'OWNER',tabname => 'MYTEST',srcpartname =>'JAN_2011',dstpartname =>'FEB_2011');
VS
DBMS_STATS.gather_table_stats (ownname => 'OWNER', tabname => 'MYTEST',partname => 'FEB_2011', estimate_percent => 33,block_sample => TRUE,
degree => 4,granularity => 'PARTITION', cascade => TRUE);
VS
Analyze Table OWNER.MYTEST Estimate Statistics Sample 33 Percent;
------------------------
Can you please tell me how can i verify them. something like check the Stats table for the changes..
Regards
Balaji Tr.