Analytic Endeavors Design - Copyright 2024-2025 Analytic Endeavors Inc. Unauthorized use prohibited.
Name
Sales
Cost
Bill
Bill
Bill
Jane
Jane
Jane
Sarah
Alice
25
25
20
20
30
30
35
25
12
12
15
16
20
20
15
12
Bill
25
12
Bill
25
12
Bill
20
15
Jane
20
16
Jane
30
20
Jane
30
20
Sarah
35
15
Alice
25
12
Bill
Bill
Bill
Jane
Jane
Jane
Sarah
Alice
25
25
20
20
30
30
35
25
12
12
15
16
20
20
15
12
Row Store
Bill
25
12
Bill
25
12
Bill
20
15
Jane
20
16
Jane
30
20
Jane
30
20
Sarah
35
15
Alice
25
12
→ Reads entire rows
→
Column Store
Bill
Bill
Bill
Jane
Jane
Jane
Sarah
Alice
25
25
20
20
30
30
35
25
12
12
15
16
20
20
15
12
↓ Reads only needed columns