#
# ORACLE Performance Tuning Chapter 17 p. 418
# Structuring the Database and SGA
    COLUMN TABLE_NAME         FORMAT A22
    COLUMN INDEX_NAME         FORMAT A22
    COLUMN COLUMN_NAME        FORMAT A22
    COLUMN COLUMN_POSITION    FORMAT A99
    COLUMN UNIQUENESS         FORMAT A6

    BREAK ON TABLE_NAME ON INDEX_NAME ON UNIQUENESS

    SELECT UIC.TABLE_NAME, 
            DECODE(UI.UNIQUENESS, 'UNIQUE','UNIQUE','') UNIQUENESS,
            UIC.INDEX_NAME, UIC.COLUMN_NAME, UIC.COLUMN_POSITION 
            FROM USER_IND_COLUMNS UIC,USER_INDEXES UI
        WHERE UI.TABLE_NAME=UIC.TABLE_NAME
        AND UI.INDEX_NAME=UIC.INDEX_NAME
        ORDER BY TABLE_NAME, INDEX_NAME, COLUMN_POSITION;