Vertica Storage model

Hybrid Storage Model

This model is the same on each HP Vertica node.

Write Optimized Store (WOS) - memory ( stored as row-store unsorted , uncompressed)

Read Optimized Store (ROS)- Disk

Tuple Mover (TM) - Moves data from memory to Disk ( Stored as column store, sorted and compressed )

With /*+direct*/ hints , Bypass WOS.