OraFAQ Forum: Server Administration » How to see index on table?

Home » RDBMS Server » Server Administration » How to see index on table?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to see index on table? [message #121456]

Sun, 29 May 2005 23:46

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

my Question is very simple....
[1] I want to see index on the table how i can see ?

please Send me Query to see the index on table.

From:- sunilkumar vishwanath mishra

Report message to a moderator

Re: How to see index on table? [message #121466 is a reply to message #121456]

Mon, 30 May 2005 00:57

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Query for
INDEX_NAME, TABLE_OWNER,TABLE_NAME in user_indexes/dba_indexes/all_indexes
to view all indexes on ur table.

Report message to a moderator

Re: How to see index on table? [message #121525 is a reply to message #121466]

Mon, 30 May 2005 07:51

srisaravankumar
Messages: 10
Registered: May 2005

Junior Member

also dba_ind_columns for the Indexed Columns

Report message to a moderator

Previous Topic:	Tablespace?
Next Topic:	Create new db schema? How?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 07:41:45 CST 2025