Oracles Hybrid Columnar Compression was one of the big new features of Oracle 11.2. Unfortunately someone decided this feature should only be available in Exadata. Even Oracle tried to explain it with technical limitations, it was more or less obvious that's just wrong. There are some reasons for this:
- The Database is doing the HCC compression all the time
- The Database must be able doing the HCC decompression in case the storage cell can not or want not.
- Beta-testers where very sure, HCC worked there without any special hardware.
- Jonathan Lewis shows there are situations, where also an ordinary database (more...)