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

1 Answer

0 votes
by (14.6k 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


Related questions

+2 votes
asked Feb 15, 2021 in Python by SakshiSharma (32.2k points)
0 votes
0 votes
asked Mar 26 in Oracle by Robin (14.6k points)
0 votes
asked Mar 23 in Oracle by john ganales (14.1k points)