Details
-
Improvement
-
Resolution: Done
-
Major
-
Morpheus
-
1
-
Analytics Sprint 3, Analytics Sprint 13, Analytics Sprint 14, Analytics Sprint 15
Description
One of the features of the new columnar format is that it keeps the min/max values for each column per mega leaf node (a multi-pages leaf node, which stores 15K tuples by default). For queries with predicates, the filters could be utilized to skip reading the columns of the tuples in a mega leaf node that do not satisfy those predicates.
For example, in the following query:
SELECT name, age, salary
|
FROM Employee
|
WHERE age BETWEEN 20 AND 30 |
AND salary > 100000 |
the columns name, age, and salary will be read if only the mega leaf node contains employees whose ages are between 20 and 30, and whose salary is greater than 100K