Forum Stats

  • 3,734,267 Users
  • 2,246,933 Discussions
  • 7,857,216 Comments

Discussions

partition and granularity co-relation when statistics are gathered ?

user11169028
user11169028 Member Posts: 17
edited Jul 29, 2016 12:53PM in General Database Discussions

Can someone help understand the functionality >>

BEGIN

dbms_stats.gather_table_stats

(ownname=>'ABC',

   tabname=>'TAB1',

   partname=>'PARTITION_X'

   estimate_percent => 100

   method_opt=> 'FOR ALL COLUMNS SIZE AUTO',

  degree=>1

  granularity=> 'ALL',

  cascade=>'TRUE');

END;

/


(Corrected the syntax by highlighting in BLUE)



1) How exactly is the difference when partition name is provided and granularity is also mentioned ??

2) What about the histograms , with relation to partition and on global level ?

Tagged:

Answers

This discussion has been closed.