Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

copy_table_stats vs gather_table_stats vs Analyze

551398Jul 6 2011 — edited Jul 7 2011
I 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.
This post has been answered by Hemant K Chitale on Jul 7 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2011
Added on Jul 6 2011
6 comments
853 views