Explanation/Reference:
Explanation:
The clause "for query" compresses it in hybrid columnar manner. The clause "low" does not compress it as aggressively. So more space is consumed but compression and decompression do not consume as much CPU. A more aggressive compression can be achieved by replacing the "low" clause with "high". This type of HCC is known as warehouse compression since it is useful for data warehouses where a lot of data is stored but they are queried frequently.