DBMS_UTILITY.ANALYZE_SCHEMA
PROCEDURE DBMS_UTILITY.ANALYZE_SCHEMA Specification
Specification:
procedure analyze_schema(
schema varchar2,
method varchar2,
estimate_rows number default null,
estimate_percent number default null,
method_opt varchar2 default null);
Description:
Analyze all the tables, clusters and indexes in a schema.
Input arguments:
schema
Name of the schema.
method
One of ESTIMATE, COMPUTE or DELETE.
If ESTIMATE, then either estimate_rows or estimate_percent
must be non-zero.
estimate_rows
Number of rows to estimate.
estimate_percent
Percentage of rows to estimate.
If estimate_rows is specified, then this parameter is ignored.
method_opt
Method options of the following format:
[ FOR TABLE ]
[ FOR ALL [INDEXED] COLUMNS] [SIZE n]
[ FOR ALL INDEXES ][@more@]
Specification:
procedure analyze_schema(
schema varchar2,
method varchar2,
estimate_rows number default null,
estimate_percent number default null,
method_opt varchar2 default null);
Description:
Analyze all the tables, clusters and indexes in a schema.
Input arguments:
schema
Name of the schema.
method
One of ESTIMATE, COMPUTE or DELETE.
If ESTIMATE, then either estimate_rows or estimate_percent
must be non-zero.
estimate_rows
Number of rows to estimate.
estimate_percent
Percentage of rows to estimate.
If estimate_rows is specified, then this parameter is ignored.
method_opt
Method options of the following format:
[ FOR TABLE ]
[ FOR ALL [INDEXED] COLUMNS] [SIZE n]
[ FOR ALL INDEXES ][@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7916042/viewspace-923519/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
分析后sql语句很快返回结果
请登录后发表评论
登录
全部评论
