Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

B28320-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$INDEXED_FIXED_COLUMN

V$INDEXED_FIXED_COLUMN displays the columns in dynamic performance tables that are indexed (X$ tables). The X$ tables can change without notice. Use this view only to write queries against fixed views (V$ views) more efficiently.

Column Datatype Description
TABLE_NAME VARCHAR2(30) Name of the dynamic performance table that is indexed
INDEX_NUMBER NUMBER Number that distinguishes to which index a column belongs
COLUMN_NAME VARCHAR2(30) Name of the column that is being indexed
COLUMN_POSITION NUMBER Position of the column in the index key (this is mostly relevant for multicolumn indexes)