0 votes
in Oracle by
Can you find out the indexes for a table in Oracle ?

1 Answer

0 votes
by

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

column_position

Related questions

0 votes
asked Mar 26, 2023 in Oracle by Robin
0 votes
asked Mar 26, 2023 in Oracle by Robin
...