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) |
Note:
1. Scripts using V$INDEXED_FIXED_COLUMN
select table_name, column_name, index_number from V$INDEXED_FIXED_COLUMN order by table_name; |
Oracle data dictionary views
Last updated: 2009-11-10 Tuesday |
No comments:
Post a Comment