Re: Viewing an Index

Do you want to see it's definition?

select * from user_indexes where table_name = 'xxx';

from there you'll see which indexes are on a table.

select * from dba_ind_columns where index_name = 'iiii';

..shows you on which exact columns the index is built.

Tanel.

<purplebelt_at_earthlink.net> wrote in message news:61a0423a.0307220930.31a76df4_at_posting.google.com...
> Can any describe how to view an index. Something like a 'select * from
> index name' would be good. The database is 8.04 Any method would help.
> Thanks
Received on Tue Jul 22 2003 - 14:32:32 CDT