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

Segment size: 1048576
Cache size: 25
Data size: 537
Cached data: 25

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



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

Segment cached: 25
Segment touched: 52
Segment cached and touched: 2


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


lo_discount
Speedup: 1.391
Segment cached: 0
Segment touched: 20
Segment cached and touched: 0


lo_quantity
Speedup: 2.670
Segment cached: 0
Segment touched: 10
Segment cached and touched: 0


lo_extendedprice
Speedup: 1.391
Segment cached: 0
Segment touched: 10
Segment cached and touched: 0


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


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




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

Segment cached: 25
Segment touched: 12
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.467
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


d_yearmonthnum
Speedup: 0.040
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0




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

Segment cached: 25
Segment touched: 6
Segment cached and touched: 1


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


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


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


lo_extendedprice
Speedup: 0.000
Segment cached: 0
Segment touched: 1
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: 25
Segment touched: 239
Segment cached and touched: 22


lo_suppkey
Speedup: 33.439
Segment cached: 18
Segment touched: 58
Segment cached and touched: 18


lo_partkey
Speedup: 64.736
Segment cached: 0
Segment touched: 58
Segment cached and touched: 0


lo_orderdate
Speedup: 0.133
Segment cached: 0
Segment touched: 58
Segment cached and touched: 0


lo_revenue
Speedup: 0.681
Segment cached: 0
Segment touched: 58
Segment cached and touched: 0


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


s_region
Speedup: 0.226
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


p_partkey
Speedup: 64.736
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


p_brand1
Speedup: 0.681
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


p_category
Speedup: 0.339
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


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


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




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

Segment cached: 25
Segment touched: 238
Segment cached and touched: 22


lo_suppkey
Speedup: 33.074
Segment cached: 18
Segment touched: 58
Segment cached and touched: 18


lo_partkey
Speedup: 69.210
Segment cached: 0
Segment touched: 58
Segment cached and touched: 0


lo_orderdate
Speedup: 0.042
Segment cached: 0
Segment touched: 58
Segment cached and touched: 0


lo_revenue
Speedup: 0.380
Segment cached: 0
Segment touched: 58
Segment cached and touched: 0


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


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


p_partkey
Speedup: 69.210
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


p_brand1
Speedup: 0.380
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


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


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




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

Segment cached: 25
Segment touched: 238
Segment cached and touched: 22


lo_suppkey
Speedup: 33.157
Segment cached: 18
Segment touched: 58
Segment cached and touched: 18


lo_partkey
Speedup: 70.534
Segment cached: 0
Segment touched: 58
Segment cached and touched: 0


lo_orderdate
Speedup: 0.374
Segment cached: 0
Segment touched: 58
Segment cached and touched: 0


lo_revenue
Speedup: 0.619
Segment cached: 0
Segment touched: 58
Segment cached and touched: 0


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


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


p_partkey
Speedup: 70.534
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


p_brand1
Speedup: 0.619
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


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


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




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

Segment cached: 25
Segment touched: 220
Segment cached and touched: 22


lo_suppkey
Speedup: 28.642
Segment cached: 18
Segment touched: 53
Segment cached and touched: 18


lo_custkey
Speedup: 36.479
Segment cached: 0
Segment touched: 53
Segment cached and touched: 0


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


lo_revenue
Speedup: 1.025
Segment cached: 0
Segment touched: 53
Segment cached and touched: 0


c_custkey
Speedup: 36.479
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


c_nation
Speedup: 1.025
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


c_region
Speedup: 0.093
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


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


s_nation
Speedup: 1.025
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


s_region
Speedup: 0.198
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


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


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




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

Segment cached: 25
Segment touched: 220
Segment cached and touched: 24


lo_suppkey
Speedup: 29.415
Segment cached: 18
Segment touched: 53
Segment cached and touched: 18


lo_custkey
Speedup: 32.983
Segment cached: 0
Segment touched: 53
Segment cached and touched: 0


lo_orderdate
Speedup: 1.512
Segment cached: 0
Segment touched: 53
Segment cached and touched: 0


lo_revenue
Speedup: 1.354
Segment cached: 0
Segment touched: 53
Segment cached and touched: 0


c_custkey
Speedup: 32.983
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


c_nation
Speedup: 0.002
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


c_city
Speedup: 1.354
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


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


s_nation
Speedup: 0.031
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


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


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


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




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

Segment cached: 25
Segment touched: 220
Segment cached and touched: 24


lo_suppkey
Speedup: 28.251
Segment cached: 18
Segment touched: 53
Segment cached and touched: 18


lo_custkey
Speedup: 29.565
Segment cached: 0
Segment touched: 53
Segment cached and touched: 0


lo_orderdate
Speedup: 1.297
Segment cached: 0
Segment touched: 53
Segment cached and touched: 0


lo_revenue
Speedup: 1.109
Segment cached: 0
Segment touched: 53
Segment cached and touched: 0


c_custkey
Speedup: 29.565
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


c_nation
Speedup: 0.000
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


c_city
Speedup: 1.109
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


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


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


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


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


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




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

Segment cached: 25
Segment touched: 16
Segment cached and touched: 5


lo_suppkey
Speedup: 0.290
Segment cached: 18
Segment touched: 2
Segment cached and touched: 0


lo_custkey
Speedup: 0.573
Segment cached: 0
Segment touched: 2
Segment cached and touched: 0


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


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


c_custkey
Speedup: 0.573
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


c_nation
Speedup: 0.000
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


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


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


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


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.008
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0




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

Segment cached: 25
Segment touched: 357
Segment cached and touched: 23


lo_suppkey
Speedup: 41.167
Segment cached: 18
Segment touched: 58
Segment cached and touched: 18


lo_custkey
Speedup: 48.424
Segment cached: 0
Segment touched: 58
Segment cached and touched: 0


lo_partkey
Speedup: 22.591
Segment cached: 0
Segment touched: 58
Segment cached and touched: 0


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


lo_revenue
Speedup: 1.290
Segment cached: 0
Segment touched: 58
Segment cached and touched: 0


lo_supplycost
Speedup: 1.290
Segment cached: 0
Segment touched: 58
Segment cached and touched: 0


c_custkey
Speedup: 48.424
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


c_nation
Speedup: 1.290
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


c_region
Speedup: 0.201
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


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


s_region
Speedup: 0.119
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


p_partkey
Speedup: 22.591
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


p_mfgr
Speedup: 0.166
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


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


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




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

Segment cached: 25
Segment touched: 100
Segment cached and touched: 5


lo_suppkey
Speedup: 9.479
Segment cached: 18
Segment touched: 15
Segment cached and touched: 0


lo_custkey
Speedup: 12.482
Segment cached: 0
Segment touched: 15
Segment cached and touched: 0


lo_partkey
Speedup: 5.282
Segment cached: 0
Segment touched: 15
Segment cached and touched: 0


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


lo_revenue
Speedup: 0.599
Segment cached: 0
Segment touched: 15
Segment cached and touched: 0


lo_supplycost
Speedup: 0.599
Segment cached: 0
Segment touched: 15
Segment cached and touched: 0


c_custkey
Speedup: 12.482
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


c_region
Speedup: 0.666
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


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


s_nation
Speedup: 0.599
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


s_region
Speedup: 0.614
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


p_partkey
Speedup: 5.282
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


p_category
Speedup: 0.599
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


p_mfgr
Speedup: 0.539
Segment cached: 0
Segment touched: 1
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.599
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1




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

Segment cached: 25
Segment touched: 100
Segment cached and touched: 6


lo_suppkey
Speedup: 8.939
Segment cached: 18
Segment touched: 15
Segment cached and touched: 0


lo_custkey
Speedup: 6.242
Segment cached: 0
Segment touched: 15
Segment cached and touched: 0


lo_partkey
Speedup: 10.431
Segment cached: 0
Segment touched: 15
Segment cached and touched: 0


lo_orderdate
Speedup: 0.658
Segment cached: 0
Segment touched: 15
Segment cached and touched: 0


lo_revenue
Speedup: 0.590
Segment cached: 0
Segment touched: 15
Segment cached and touched: 0


lo_supplycost
Speedup: 0.590
Segment cached: 0
Segment touched: 15
Segment cached and touched: 0


c_custkey
Speedup: 6.242
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


c_region
Speedup: 0.000
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


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


s_nation
Speedup: 0.117
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


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


p_partkey
Speedup: 10.431
Segment cached: 1
Segment touched: 1
Segment cached and touched: 1


p_brand1
Speedup: 0.590
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


p_category
Speedup: 0.069
Segment cached: 0
Segment touched: 1
Segment cached and touched: 0


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


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