0 votes
in Oracle by (13.1k points)
Can you find out the indexes for a table in Oracle ?

1 Answer

0 votes
by (13.1k points)

This is the basic syntax that is  used  to find out the indexes  for  a table in Oracle.

SELECT owner, index_name,

tablespace_name, status

Set pages

Break on table_name on index_name

column table_name

column index_name

column column_name

select table_name, index_name, column_name

from dba_ind_columns

where table_owner

order by table_name, index_name