Oracle 视图 ALL_CLUSTERING_KEYS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_CLUSTERING_KEYS视图是Oracle数据库中用于描述在特定群集表中为群集列定义的索引所使用的搜索键列的系统视图，用于获取某个群集表中定义的群集索引所使用的键列的表示形式，在更新集群索引时也可以非常好地使用这张视图。
使用ALL_CLUSTERING_KEYS视图的方法：
1、首先，确定要查询的表名，即需要查询的群集索引。比如在查询表“emp_cluster”中的群集索引：
2、使用如下SQL查询：SELECT * FROM ALL_CLUSTERING_KEYS WHERE TABLE_NAME = ‘EMP_CLUSTER’；
3、SELECT语句会返回表“EMP_CLUSTER”中定义的群集索引所使用的键列。
官方英文解释
ALL_CLUSTERING_KEYS describes clustering keys for tables with an attribute clustering clause accessible to the user.
Related Views
-
DBA_CLUSTERING_KEYSdescribes clustering keys for all tables with an attribute clustering clause. -
USER_CLUSTERING_KEYSdescribes clustering keys for tables with an attribute clustering clause owned by the user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the table on which the clustering clause is defined |
|
|
|
|
Name of the table on which the clustering clause is defined |
|
|
|
|
Owner of the detailed table contributing to the clustering keys |
|
|
|
|
Name of the detailed table contributing to the clustering keys |
|
|
|
|
Name of the detail column |
|
|
|
|
Position of the column in the clustering clause |
|
|
|
|
Group ID of the column in the clustering clause |
See Also:
-
“DBA_CLUSTERING_KEYS”
-
“USER_CLUSTERING_KEYS”
-
The
ALTER TABLEsection in Oracle Database SQL
Language Reference for information about using theCLUSTERINGclause to create an attribute clustering table -
The
CREATE TABLEsection in Oracle Database SQL
Language Reference for information about using theCLUSTERINGclause to create an attribute clustering table -
Oracle Database Data
Warehousing Guide for information about dimension tables -
Oracle Database Data
Warehousing Guide for information about attribute clustering with zone maps
