Restrictions on Analyzing Tables
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部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-1001628/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Analyzing and Reproducing the EOS Out-of-Bound Write Vulnerability in nodeos
- Oracle TablesOracle
- 如何在 SAP 電商雲裡設定 Time RestrictionsREST
- mysql關於FLUSH TABLES和FLUSH TABLES WITH READ LOCK的理解MySql
- mysqld --skip-grant-tablesMySql
- CRICOS Data Structures and AlgorithmsHash TablesStructGo
- How Logs Work On MySQL With InnoDB TablesMySql
- HDU1213-How Many Tables
- Moving Tables(貪心演算法)演算法
- the --skip-grant-tables option so it cannot
- 2020-10-21 pandas - tables關係
- Oracle 19c Concepts(02):Tables and Table ClustersOracle
- [20181112]Private Temporary Tables Oracle Database 18C.txtOracleDatabase
- PostgreSQL 原始碼解讀(201)- PG 12 BlackholeAM for tablesSQL原始碼
- Oracle 19c Concepts(03):Indexes and Index-Organized TablesOracleIndexZed
- Vue.js 可排序列表 (Sortable & Searchable Tables) 元件Vue.js排序元件
- mysql show open tables相關知識體系之一MySql
- Oracle:ORA-01219:database not open:queries allowed on fixed tables/views onlyOracleDatabaseView
- create table,show tables,describe table,DROP TABLE,ALTER TABLE ,怎麼使用?
- ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables optErrorMySqlServer
- MySQL 8.0 Reference Manual(讀書筆記57節--Optimizing for InnoDB Tables)MySql筆記
- 【OCP最新題庫解析(052)--題3】Which two are true about external tables?
- PostgreSQL 原始碼解讀(200)- PG 12 Pluggable storage for tables介面淺析SQL原始碼
- Mit6.S081筆記Lab3: page tables 頁表MIT筆記
- MySQL 使用 show tables 時出現 ERROR 1449 (HY000) 問題MySqlError
- Oracle 12c系列(十) | 12c中的Recovering Tables and Table PartitionsOracle
- 深入理解mysqldump原理 --single-transaction --lock-all-tables --master-dataMySqlAST
- Oracle 12C新特性-資料泵新引數(VIEWS_AS_TABLES)OracleView
- Oracle 20c 新特性:原生的區塊鏈支援 Native Blockchain tablesOracle區塊鏈Blockchain
- 查詢結果集很小,但 Created_tmp_disk_tables 不斷增加
- Linux:ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannLinuxErrorMySqlServer
- MySQL 8.0 Reference Manual(讀書筆記86節-- InnoDB INFORMATION_SCHEMA Tables(2))MySql筆記ORM
- MySQL 8.0 Reference Manual(讀書筆記85節-- InnoDB INFORMATION_SCHEMA Tables(1))MySql筆記ORM
- 【12.2】Oracle 12C R2新特性-外部表支援分割槽了(Partitioning External Tables)Oracle
- MySQL 8.0 Reference Manual(讀書筆記52節--Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions(2))MySql筆記ViewExpress
- MySQL 8.0 Reference Manual(讀書筆記51節--Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions(1))MySql筆記ViewExpress