How to obtain Cluster Columns in a database

How to obtain Cluster Columns in a database

I have a view which does that but it runs very slow even for a small oracle database.

select t.owner,t.table_name, cl.COLUMN_ID, cl.COLUMN_NAME

    FROM sys.all_tables t, sys.all_tab_columns cl     WHERE t.cluster_name is not NULL

        AND t.owner = c1.owner
    AND t.cluster_name = c1.table_name Received on Thu Apr 11 2002 - 19:25:58 CDT