Gathering Stats

exec DBMS_STATS.GATHER_TABLE_STATS(          ownname=>'SCHEMA_OWNER',
                                             tabname=>'SOME_TABLE',
                                              degree=>16,
                                   estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,
                                         method_opt => 'FOR ALL COLUMNS SIZE AUTO',
                                        granularity => 'AUTO',
                                            cascade => TRUE,
                                      no_invalidate => FALSE);

Leave a Reply

Your email address will not be published. Required fields are marked *