Oracle indexes

[BigDude]

I need to know how to find what column an index is against . I used the following query to determine how many indexs are on the table.

SQL> select * from user_indexes where index_name like 'CARDHLDR_CONTACT%';

But , the result doesnt identify the column indexed.

Any ideas?

 

[amolso]

'Select * from user_indexes' will not serve purpose rightly as it will display all the columns unncessarily. Instead of this you can use USER_IND_COLUMNS. It looks like you know the index name , the table and column name can be found in this view. For other details see the USER_INDEXES view.

I hope this will help
Amol New to dba world, so please ......

 

[Guest_imported]

select * from dba_ind_columns;

 

[carp]

SELECT index_name, column_name
FROM dba_ind_columns
WHERE index_name LIKE 'CARDHLDR_CONTACT%'
ORDER BY position;

The ORDER BY clause will arrange the columns in the order they're referenced in the index in the event that you have a composite index.