Database DataWarehousing (MOSC)

MOSC Banner

Small index will not be compressed - In the output log for compression

edited Jun 25, 2015 10:01AM in Database DataWarehousing (MOSC) 1 commentAnswered

Hi,

while doing compression all the table objects and most of the indexes are got compressed except like more than 255 columns, already sap compressed objects, few exceptional static tables.

But there was huge no of Small indexes are not getting compressed why ??? is it coz of candidate for considering object to be compressed depends on size of the objects as well.(min it should be

more than some MB etc..).

coz, when we analyze the logs,it has more than 80% of objects are not compressed warning since small index will not be compressed ..

Please provide your wise ideas/tricks handle above scienorious.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center