收集统计信息

BEGIN
  DBMS_STATS.GATHER_TABLE_STATS(ownname => 'TAB_OWNER',
    tabname          => 'TAB_NAME',
    estimate_percent => 根据表大小设置,
    method_opt       => 'for all columns size repeat',
    no_invalidate    => FALSE,
    degree           => 根据表大小，CPU资源和负载设置,
    granularity      => 'AUTO',
    cascade          => TRUE);
END;
/