Viewing an Index

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 23 Jul 2003 09:50:53 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703F18B85@lnewton.leeds.lfs.co.uk>

-----Original Message-----
From: Tanel Poder [mailto:tanel@@peldik.com]

>> 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.

And, when you have the column names and order they are in, you can do :

select rowid, column_1, column_2 .....
from table_name;

and you will see the contents of the index :o)

Cheers,
Norm.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

Received on Wed Jul 23 2003 - 03:50:53 CDT