Does the delta merge include any sort of compression.

[Former Member]

Hello Gurus,

I have a table with the (total_memory consumption(kb)= 40: (main storage(kb): 8 + delta storage(kb):32)) when i go ahead and perform a delta merge on the table i see a behavior where the size of the table is changed (total_memory consumption(kb)= 24 (main storage(kb): 9 + delta storage(kb): 15))

I have learnt that when the delta merge is performed the tuples from delta storage gets merged with the main storage of the same table, so why is there a change in the memory consumption ? Is there a compression technique involved in the delta merge process? if so can you please let me know what it is.

Thanks in advance.

Regards,

Krishna.

[former_member182302 · Accepted solution]

Hi Krishna,

Have a look on this discussion

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Thank you Krishna the document is really helpful , It was indeed a very Clear explanation by lars.

Thanks,

Krishna