===========================
=======  CACHE INFO  ======
===========================

Segment size: 1048576
Cache size: 400
Data size: 2084
Cached data: 399

lo_suppkey: 160/229 segments cached
lo_custkey: 111/229 segments cached
lo_partkey: 105/229 segments cached
lo_orderdate: 0/229 segments cached
lo_revenue: 0/229 segments cached
lo_discount: 0/229 segments cached
lo_quantity: 0/229 segments cached
lo_extendedprice: 0/229 segments cached
lo_supplycost: 0/229 segments cached
c_custkey: 2/2 segments cached
c_nation: 2/2 segments cached
c_region: 2/2 segments cached
c_city: 2/2 segments cached
s_suppkey: 1/1 segments cached
s_nation: 1/1 segments cached
s_region: 1/1 segments cached
s_city: 1/1 segments cached
p_partkey: 2/2 segments cached
p_brand1: 2/2 segments cached
p_category: 2/2 segments cached
p_mfgr: 2/2 segments cached
d_datekey: 1/1 segments cached
d_year: 1/1 segments cached
d_yearmonthnum: 1/1 segments cached



===========================
========  QUERY 11 ========
===========================

Segment cached: 399
Segment touched: 182
Segment cached and touched: 2


lo_orderdate
Speedup: 0.000
Segment cached: 0
Segment touched: 36
Segment cached and touched: 0


lo_discount
Speedup: 0.000
Segment cached: 0
Segment touched: 72
Segment cached and touched: 0


lo_quantity
Speedup: 0.000
Segment cached: 0
Segment touched: 36
Segment cached and touched: 0


lo_extendedprice
Speedup: 0.000
Segment cached: 0
Segment touched: 36
Segment cached and touched: 0


d_datekey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_year
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1




===========================
========  QUERY 12 ========
===========================

Segment cached: 399
Segment touched: 17
Segment cached and touched: 2


lo_orderdate
Speedup: 0.000
Segment cached: 0
Segment touched: 3
Segment cached and touched: 0


lo_discount
Speedup: 0.000
Segment cached: 0
Segment touched: 6
Segment cached and touched: 0


lo_quantity
Speedup: 0.000
Segment cached: 0
Segment touched: 3
Segment cached and touched: 0


lo_extendedprice
Speedup: 0.000
Segment cached: 0
Segment touched: 3
Segment cached and touched: 0


d_datekey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_yearmonthnum
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1




===========================
========  QUERY 13 ========
===========================

Segment cached: 399
Segment touched: 11
Segment cached and touched: 1


lo_orderdate
Speedup: 0.000
Segment cached: 0
Segment touched: 2
Segment cached and touched: 0


lo_discount
Speedup: 0.000
Segment cached: 0
Segment touched: 4
Segment cached and touched: 0


lo_quantity
Speedup: 0.000
Segment cached: 0
Segment touched: 2
Segment cached and touched: 0


lo_extendedprice
Speedup: 0.000
Segment cached: 0
Segment touched: 2
Segment cached and touched: 0


d_datekey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1




===========================
========  QUERY 21 ========
===========================

Segment cached: 399
Segment touched: 154
Segment cached and touched: 82


lo_suppkey
Speedup: 0.000
Segment cached: 160
Segment touched: 36
Segment cached and touched: 36


lo_partkey
Speedup: 0.000
Segment cached: 105
Segment touched: 36
Segment cached and touched: 36


lo_orderdate
Speedup: 0.000
Segment cached: 0
Segment touched: 36
Segment cached and touched: 0


lo_revenue
Speedup: 0.000
Segment cached: 0
Segment touched: 36
Segment cached and touched: 0


s_suppkey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_region
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


p_partkey
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


p_brand1
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


p_category
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


d_datekey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_year
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1




===========================
========  QUERY 22 ========
===========================

Segment cached: 399
Segment touched: 288
Segment cached and touched: 148


lo_suppkey
Speedup: 0.000
Segment cached: 160
Segment touched: 70
Segment cached and touched: 70


lo_partkey
Speedup: 0.000
Segment cached: 105
Segment touched: 70
Segment cached and touched: 70


lo_orderdate
Speedup: 0.000
Segment cached: 0
Segment touched: 70
Segment cached and touched: 0


lo_revenue
Speedup: 0.000
Segment cached: 0
Segment touched: 70
Segment cached and touched: 0


s_suppkey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_region
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


p_partkey
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


p_brand1
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


d_datekey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_year
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1




===========================
========  QUERY 23 ========
===========================

Segment cached: 399
Segment touched: 568
Segment cached and touched: 183


lo_suppkey
Speedup: 0.000
Segment cached: 160
Segment touched: 140
Segment cached and touched: 105


lo_partkey
Speedup: 0.000
Segment cached: 105
Segment touched: 140
Segment cached and touched: 70


lo_orderdate
Speedup: 0.000
Segment cached: 0
Segment touched: 140
Segment cached and touched: 0


lo_revenue
Speedup: 0.000
Segment cached: 0
Segment touched: 140
Segment cached and touched: 0


s_suppkey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_region
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


p_partkey
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


p_brand1
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


d_datekey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_year
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1




===========================
========  QUERY 31 ========
===========================

Segment cached: 399
Segment touched: 151
Segment cached and touched: 81


lo_suppkey
Speedup: 0.000
Segment cached: 160
Segment touched: 35
Segment cached and touched: 35


lo_custkey
Speedup: 0.000
Segment cached: 111
Segment touched: 35
Segment cached and touched: 35


lo_orderdate
Speedup: 0.000
Segment cached: 0
Segment touched: 35
Segment cached and touched: 0


lo_revenue
Speedup: 0.000
Segment cached: 0
Segment touched: 35
Segment cached and touched: 0


c_custkey
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


c_nation
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


c_region
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


s_suppkey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_nation
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_region
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_datekey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_year
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1




===========================
========  QUERY 32 ========
===========================

Segment cached: 399
Segment touched: 291
Segment cached and touched: 116


lo_suppkey
Speedup: 0.000
Segment cached: 160
Segment touched: 70
Segment cached and touched: 70


lo_custkey
Speedup: 0.000
Segment cached: 111
Segment touched: 70
Segment cached and touched: 35


lo_orderdate
Speedup: 0.000
Segment cached: 0
Segment touched: 70
Segment cached and touched: 0


lo_revenue
Speedup: 0.000
Segment cached: 0
Segment touched: 70
Segment cached and touched: 0


c_custkey
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


c_nation
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


c_city
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


s_suppkey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_nation
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_city
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_datekey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_year
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1




===========================
========  QUERY 33 ========
===========================

Segment cached: 399
Segment touched: 571
Segment cached and touched: 256


lo_suppkey
Speedup: 0.000
Segment cached: 160
Segment touched: 140
Segment cached and touched: 140


lo_custkey
Speedup: 0.000
Segment cached: 111
Segment touched: 140
Segment cached and touched: 105


lo_orderdate
Speedup: 0.000
Segment cached: 0
Segment touched: 140
Segment cached and touched: 0


lo_revenue
Speedup: 0.000
Segment cached: 0
Segment touched: 140
Segment cached and touched: 0


c_custkey
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


c_nation
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


c_city
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


s_suppkey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_nation
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_city
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_datekey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_year
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1




===========================
========  QUERY 34 ========
===========================

Segment cached: 399
Segment touched: 23
Segment cached and touched: 14


lo_suppkey
Speedup: 0.000
Segment cached: 160
Segment touched: 3
Segment cached and touched: 3


lo_custkey
Speedup: 0.000
Segment cached: 111
Segment touched: 3
Segment cached and touched: 0


lo_orderdate
Speedup: 0.000
Segment cached: 0
Segment touched: 3
Segment cached and touched: 0


lo_revenue
Speedup: 0.000
Segment cached: 0
Segment touched: 3
Segment cached and touched: 0


c_custkey
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


c_nation
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


c_city
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


s_suppkey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_nation
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_city
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_datekey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_yearmonthnum
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1




===========================
========  QUERY 41 ========
===========================

Segment cached: 399
Segment touched: 230
Segment cached and touched: 122


lo_suppkey
Speedup: 0.000
Segment cached: 160
Segment touched: 36
Segment cached and touched: 36


lo_custkey
Speedup: 0.000
Segment cached: 111
Segment touched: 36
Segment cached and touched: 36


lo_partkey
Speedup: 0.000
Segment cached: 105
Segment touched: 36
Segment cached and touched: 36


lo_orderdate
Speedup: 0.000
Segment cached: 0
Segment touched: 36
Segment cached and touched: 0


lo_revenue
Speedup: 0.000
Segment cached: 0
Segment touched: 36
Segment cached and touched: 0


lo_supplycost
Speedup: 0.000
Segment cached: 0
Segment touched: 36
Segment cached and touched: 0


c_custkey
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


c_nation
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


c_region
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


s_suppkey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_region
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


p_partkey
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


p_mfgr
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


d_datekey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_year
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1




===========================
========  QUERY 42 ========
===========================

Segment cached: 399
Segment touched: 351
Segment cached and touched: 149


lo_suppkey
Speedup: 0.000
Segment cached: 160
Segment touched: 56
Segment cached and touched: 56


lo_custkey
Speedup: 0.000
Segment cached: 111
Segment touched: 56
Segment cached and touched: 42


lo_partkey
Speedup: 0.000
Segment cached: 105
Segment touched: 56
Segment cached and touched: 36


lo_orderdate
Speedup: 0.000
Segment cached: 0
Segment touched: 56
Segment cached and touched: 0


lo_revenue
Speedup: 0.000
Segment cached: 0
Segment touched: 56
Segment cached and touched: 0


lo_supplycost
Speedup: 0.000
Segment cached: 0
Segment touched: 56
Segment cached and touched: 0


c_custkey
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


c_region
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


s_suppkey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_nation
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_region
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


p_partkey
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


p_category
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


p_mfgr
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


d_datekey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_year
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1




===========================
========  QUERY 43 ========
===========================

Segment cached: 399
Segment touched: 855
Segment cached and touched: 260


lo_suppkey
Speedup: 0.000
Segment cached: 160
Segment touched: 140
Segment cached and touched: 105


lo_custkey
Speedup: 0.000
Segment cached: 111
Segment touched: 140
Segment cached and touched: 70


lo_partkey
Speedup: 0.000
Segment cached: 105
Segment touched: 140
Segment cached and touched: 70


lo_orderdate
Speedup: 0.000
Segment cached: 0
Segment touched: 140
Segment cached and touched: 0


lo_revenue
Speedup: 0.000
Segment cached: 0
Segment touched: 140
Segment cached and touched: 0


lo_supplycost
Speedup: 0.000
Segment cached: 0
Segment touched: 140
Segment cached and touched: 0


c_custkey
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


c_region
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


s_suppkey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_nation
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


s_city
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


p_partkey
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


p_brand1
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


p_category
Speedup: 0.000
Segment cached: 2
Segment touched: 2
Segment cached and touched: 2


d_datekey
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


d_year
Speedup: 0.000
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1