Re: which columns are indexed

where index_name = 'EI_ATTRSTORE'

INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH DESCEND
----------- ---------- ----------- ------------ ----------- --------------- ------------- -------

ODS         EI_ATTRSTORE   ODS         DS_ATTRSTORE ENTRYID
1               22            ASC

so if you want to know which columns have been indexed in a table, simply execute the query:

select index_name, column_name
from all_ind_columns
where table_name = 'MYTABLE';

cheers

Richard Scrivener
Sydney
Australia

A D Hager wrote:

> Is there any way to determine which columns in a table have been
> indexed?
> Is there any way to determine what ann index indexes?
>
> Thanks,
>
> Aaron

--