DBA_IND_COLUMNS

Oracle 11gR1

DBA_IND_COLUMNS describes the columns of all the indexes on all tables and clusters in the database. Its columns are the same as those in "ALL_IND_COLUMNS".

Note:

For join indexes, the TABLE_NAME and TABLE_OWNER columns in this view may not match the TABLE_NAME and TABLE_OWNER columns you find in the *_INDEXES (and other similar) data dictionary views.

Related Views

· ALL_IND_COLUMNS describes the columns of indexes on all tables accessible to the current user.

· USER_IND_COLUMNS describes the columns of indexes owned by the current user and columns of indexes on tables owned by the current user. This view does not display the INDEX_OWNER or TABLE_OWNER columns.

Column	Datatype	NULL	Description
INDEX_OWNER	VARCHAR2(30)	NOT NULL	Owner of the index
INDEX_NAME	VARCHAR2(30)	NOT NULL	Name of the index
TABLE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the table or cluster
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table or cluster
COLUMN_NAME	VARCHAR2(4000)		Column name or attribute of object type column Note: If you create an index on a user-defined REF column, the system creates the index on the attributes that make up the REF column. Therefore, the column names displayed in this view are the attribute names, with the REF column name as a prefix, in the following form: "REF_name"."attribute"
COLUMN_POSITION	NUMBER	NOT NULL	Position of column or attribute within the index
COLUMN_LENGTH	NUMBER	NOT NULL	Indexed length of the column
CHAR_LENGTH	NUMBER		Maximum codepoint length of the column
DESCEND	VARCHAR2(4)		Whether the column is sorted in descending order (Y/N)

Note:

1. Show indexed columns

Select *

from dba_ind_columns

where index_name = 'I_USER1'

order by column_position;

INDEX_ OWNER	INDEX_ NAME	TABLE_ OWNER	TABLE_ NAME	COLUMN_ NAME	COLUMN_ POSITION	COLUMN_ LENGTH	CHAR_ LENGTH	DESCEND
SYS	I_USER1	SYS	USER$	NAME	1	30	30	ASC

Oracle data dictionary views

Oracle dynamic performance views