Home » SQL & PL/SQL » SQL & PL/SQL » index in oracle
index in oracle [message #245423] Sun, 17 June 2007 00:36 Go to next message
mkumar26
Messages: 3
Registered: June 2007
Junior Member
hi,


i have a table some x

how can i see that table how many columns are indexed ............


my answer is:


using explain plan set auto trace on command only possible is it correct... or not...
Re: index in oracle [message #245428 is a reply to message #245423] Sun, 17 June 2007 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
user/all/dba_ind_columns

Regards
Michel
Re: index in oracle [message #245440 is a reply to message #245423] Sun, 17 June 2007 04:15 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

select column_name, index_name from dba_indexes where table_name-'<table_name>';
Re: index in oracle [message #245464 is a reply to message #245440] Sun, 17 June 2007 12:41 Go to previous message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select column_name, index_name from dba_indexes ;
select column_name, index_name from dba_indexes
       *
ERROR at line 1:
ORA-00904: "COLUMN_NAME": invalid identifier

If you don't execute the query you posted, at least verify you don't write wrong things.
COLUMN_NAME is not, was never, will never be in the %indexes views.

Moreover, it would be great if you read the other posts BEFORE posting yourself.

Regards
Michel
Previous Topic: Create view from the result of a function which returns ref cursor
Next Topic: PLS-00306: wrong number or types of arguments in call
Goto Forum:
  


Current Time: Mon Dec 05 03:05:20 CST 2016

Total time taken to generate the page: 0.24000 seconds