Voici ses principaux champs :
| Nom du champ | Type du champ | Description du champ |
| index_name | VarChar | Nom de l'index. |
| owner | VarChar | Nom de la table. |
| table_name | VarChar | Nom de la table. |
| uniqueness | VarChar | Y si unique. |
SELECT
b.owner,
'',
b.tablespace_name,
b.table_name,
a.index_name,
DECODE(a.uniqueness,
'Y', 1,
0),
c.column_name,
c.column_position
FROM ALL_INDEXES a, ALL_TABLES b, ALL_IND_COLUMNS c
WHERE
a.owner=b.owner
AND a.table_name=b.table_name
AND a.owner=c.index_owner
AND a.index_name=c.index_name
AND a.table_name=c.table_name
AND b.tablespace_name LIKE 'MonEspace%'
AND a.table_name LIKE 'MaTable%'
ORDER BY b.tablespace_name, b.table_name, a.index_name, c.column_position;