Index compression

Oracle index compression: eliminating duplicate column values

Index compression comes from Oracle 8i and has quite the same mechanism as table compression. Index compression eliminates duplicate column values in the leaf blocks. Let's see how it works:(…)