本站中文解释

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_KEYS describes clustering keys for all tables with an attribute clustering clause.

• USER_CLUSTERING_KEYS describes clustering keys for tables with an attribute clustering clause owned by the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(128)	NOT NULL	Owner of the table on which the clustering clause is defined
TABLE_NAME	VARCHAR2(128)	NOT NULL	Name of the table on which the clustering clause is defined
DETAIL_OWNER	VARCHAR2(128)	NOT NULL	Owner of the detailed table contributing to the clustering keys
DETAIL_NAME	VARCHAR2(128)	NOT NULL	Name of the detailed table contributing to the clustering keys
DETAIL_COLUMN	VARCHAR2(128)	NOT NULL	Name of the detail column
POSITION	NUMBER	NOT NULL	Position of the column in the clustering clause
GROUPID	NUMBER	NOT NULL	Group ID of the column in the clustering clause

See Also:

• “DBA_CLUSTERING_KEYS”

• “USER_CLUSTERING_KEYS”

• The ALTER TABLE section in Oracle Database SQL
  Language Reference for information about using the CLUSTERING clause to create an attribute clustering table

• The CREATE TABLE section in Oracle Database SQL
  Language Reference for information about using the CLUSTERING clause 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

---

编辑：一起学习网

标签：索引,视图,定义,也可,这张