Analyzing tables is subject to the following restrictions:
■ You cannot use ANALYZE to collect statistics on data dictionary tables.
■ You cannot use ANALYZE to collect statistics on an external table. Instead, you
must use the DBMS_STATS package.
■ You cannot use ANALYZE to collect default statistics on a temporary table.
However, if you have already created an association between one or more columns
of a temporary table and a user-defined statistics type, then you can use ANALYZE
to collect the user-defined statistics on the temporary table.
■ You cannot compute or estimate statistics for the following column types: REF
column types, varrays, nested tables, LOB column types (LOB column types are
not analyzed, they are skipped), LONG column types, or object types. However, if a
statistics type is associated with such a column, then Oracle Database collects
user-defined statistics.[@more@]
■ You cannot use ANALYZE to collect statistics on data dictionary tables.
■ You cannot use ANALYZE to collect statistics on an external table. Instead, you
must use the DBMS_STATS package.
■ You cannot use ANALYZE to collect default statistics on a temporary table.
However, if you have already created an association between one or more columns
of a temporary table and a user-defined statistics type, then you can use ANALYZE
to collect the user-defined statistics on the temporary table.
■ You cannot compute or estimate statistics for the following column types: REF
column types, varrays, nested tables, LOB column types (LOB column types are
not analyzed, they are skipped), LONG column types, or object types. However, if a
statistics type is associated with such a column, then Oracle Database collects
user-defined statistics.[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-1001628/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
ANALYZE TABLE
下一篇：
VALIDATE STRUCTURE
请登录后发表评论
登录
全部评论
-
博文量740
-
访问量2002853
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
