Как собрать статистику в oracle?

1
2
3
4
5
6
7

BEGIN
  DBMS_STATS.GATHER_TABLE_STATS(
    ownname => '<schema>', 
    tabname => '<table>',
    estimate_percent => <percent>
  );
END;

1

ANALYZE TABLE <schema>.<table> COMPUTE STATISTICS;

1

EXPORT TABLE <schema>.<table> STATISTICS TO <file>.STA;

1

IMPORT TABLE <schema>.<table> STATISTICS FROM <file>.STA;

1
2
3
4
5

SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(
  ownname => '<schema>', 
  tabname => '<table>',
  estimate_percent => <percent>
);