HCC compression and UPDATES
skurup2Dec 29 2011 — edited Nov 22 2012We use HCC QH compression for older partitions and we have a requirement to update some of these older partitions. From what I read in documents, those updated records will get converted to OLTP compression format. If this is the case, how do I convert these records back to HCC QH compression.
Are there any commands to find those records changed from HCC-QH to OLTP and commands to convert them back to HCC. I am thinking of implementing a weekly mainteance process to do those steps to locate OLTP and convert to HCC-QH.
- Sreeni