Re: which columns are indexed

"A D Hager" <adhager_at_its.brooklyn.cuny.edu> wrote in message news:397339CB.978FF636_at_its.brooklyn.cuny.edu...
> 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
>
>
>

select column_name, index_name, column_position from dba_ind_columns (or all_ind_columns, or user_ind_columns)

select owner, table_name, index_name, column_name from dba_ind_columns
order by owner, table_name, index_name, column_position

Could you please refrain in the future of posting to *all* Oracle newsgroups? There's really no need to do so. Anything referring to the dictionary should be posted preferably in .server.

Regards,

Sybrand Bakker, Oracle DBA Received on Mon Jul 17 2000 - 00:00:00 CDT