8 Replies Latest reply: Apr 3, 2008 9:14 AM by 591186 RSS

    DBMS_STATS.GATHER_TABLE_STATS & DBMS_STATS.GATHER_SCHEMA_STATS

    614497
      Hi All,

      In the GATHER_TABLE_STATS or GATHER_SCHEMA_STATS procedures if for parameter method_opt we use 'FOR ALL INDEXED COLUMNS size skewonly', does this mean we only collect stats for index columns or collect stats for all columns in the table?

      Thanks a lot,

      Shirley