Topic
No replies
Ratnalein
Ratnalein
18 Posts
ACCEPTED ANSWER

Pinned topic COMPRESS YES --> still need REORG TABLE?

‏2012-09-27T17:27:16Z |
Hallo everyone,

in my ddl-File, I did COMPRESS YES to decrease the Bytes used. If I am not mistake, with COMPRESS YES, there will be a dictionary created. Since I often have to LOAD datas in the table, I would be nice: after a LOAD command, the dictionary will be updated/recreated.

I am thinking about REORG command after each LOAD. But I am not sure. Thats why, my question:
what is the best practice for this aim?

Thank you for your help..

Regards,
Ratna