Oralce查询索引的语句，

Oralce查询索引的语句，

SELECT   i.owner AS index_owner, i.index_name, i.table_owner, i.table_name,
         i.uniqueness, c.column_position, c.column_name, c.descend,
         i.index_type, i.GENERATED, i.status, i.last_analyzed
    FROM all_indexes i, all_ind_columns c
   WHERE i.table_name = 'ODS_CAR_PRPCCOINS' --tablename
     AND (i.owner = 'ODS_USER' OR i.table_owner = 'ODS_USER')  -- user
     AND i.index_name = c.index_name
     AND i.table_owner = c.table_owner
     AND i.table_name = c.table_name
     AND i.owner = c.index_owner
ORDER BY i.owner, i.table_name, i.index_name, c.column_position

 

SELECT 
    * 
FROM 
    sys.all_indexes