how to find all indexes and their columns for tables views and synonyms in oracle

Question

I jotted down the following query which will list the index name and its columns for a particular table   select  b uniqueness  a index name  a table name  a column name  from all ind columns a  all indexes b where a index name b index name  and a table name   upper  table name   order by a table name  a index name  a column position    I want to modify this so that if I pass in a view or synonym also it works  Our system has variations of views  synonyms so it will be really helpful to have one query to which i can just supply the name  be it view synonym or table  and it would spit out the indexes and their columns

User · Accepted Answer

Your query should work for synonyms as well as the tables  However  you seem to expect indexes on views where there are not  Maybe is it materialized views

User · Answer

SELECT       FROM user cons columns    WHERE table name    table name

[oracle] how to find all indexes and their columns for tables, views and synonyms in oracle

Examples related to oracle