Oracle資料庫的資料統計(Analyze)

 

CREATE OR REPLACE PROCEDURE PRO_Analyze_Table(p_name             VARCHAR2,
                                             p_method           VARCHAR2 := 'ESTIMATE',
                                             p_estimate_rows    NUMBER := null,
                                             p_estimate_percent NUMBER := 50,
                                             p_method_opt       VARCHAR2 := 'FOR TABLE',
                                             p_type             VARCHAR2 := 'TABLE',
                                             p_partname         VARCHAR2 := null)
  AUTHID CURRENT_USER AS
  p_schema VARCHAR2(2000) := USER;
BEGIN
  /* p_type TABLE, CLUSTER or INDEX */
  DBMS_DDL.ANALYZE_OBJECT(p_type,
                          p_schema,
                          p_name,
                          p_method,
                          p_estimate_rows,
                          p_estimate_percent,
                          p_method_opt,
                          p_partname);
END ;