0

indexes and compression on raw tables

We see that some options on table are only applied to the valid and not to the raw table.

-Indexes
-Table compression (also indexes on the valid don't take over the compression of the table, they stay uncompressed)

In order to minimize disk writing and optimize performance we uncheck "Physical valid table" regularly, but then these indexes and compressions get lost. Also in full load scenario's the compression on the raw is as important as the compression on the valid.

I believe that we would benefit from having these options also applied to the raw table and the indexes.

Regards
Dirk

0 comments

Please sign in to leave a comment.