How to get list of indexes compressed using Key Compression !!

[former_member69568]

Hi....Experts.

How can i find out INDEXES compresses in my system using Index Key compression as explained in Note #1109743

Ref : SAP Note 1109743 - Use of Index Key Compression for Oracle Databases

Ref :

(or)

I got a foolish question in my mind,

Rgds

[Former Member · Accepted solution]

Hi,

Check Section 17 of Note 1289494 - FAQ: Oracle compression

How do I determine which tables and indexes have active compression?

SELECT

OWNER,

INDEX_NAME,

NULL PARTITION_NAME,

PREFIX_LENGTH

FROM

DBA_INDEXES

WHERE

COMPRESSION = 'ENABLED'

UNION ALL

( SELECT

INDEX_OWNER OWNER,

INDEX_NAME,

PARTITION_NAME,

NULL PREFIX_LENGTH

FROM

DBA_IND_PARTITIONS

WHERE

COMPRESSION = 'ENABLED'

)

ORDER BY

OWNER,

INDEX_NAME;

Hope it helps.

Thanks

Sushil

[former_member69568 · Accepted solution]

SUSHIL THANK - YOU ....GOT EXACTLY WHAT I WANT