—查询表是否需要更新统计STALE_STATS=YES则是需要

    select a.STALE_STATS,a.* from dba_tab_statistics a where a.OWNER=’GDHIS’ and a.TABLE_NAME=’LCYHGL_YZJJFS’;

    —收集指定表的统计信息
    BEGIN
    DBMS_STATS.GATHER_TABLE_STATS(ownname =>’GDHIS’,tabname =>’LCYHGL_BAZY’, estimate_percent => 100, method_opt => ‘for all columns size auto’, degree => 8, cascade=>TRUE );
    END;