resultcache_master_vs_v8_vs_v9_big.csv

application/vnd.ms-excel

Filename: resultcache_master_vs_v8_vs_v9_big.csv

Type: application/vnd.ms-excel

Part: 1

Message: Re: Hybrid Hash/Nested Loop joins and caching results from subplans

lookup1,count(*),thousand,6686.179,2950.66,3217.514
lookup1,count(*),hundred,4495.967,3111.354,3301.798
lookup1,count(*),ten,4377.59,2925.131,3159.214
lookup1,count(*),one,4467.683,2912.478,3214.049
lookup1,count(l.a),thousand,6714.409,3152.067,3422.33
lookup1,count(l.a),hundred,4551.304,3231.036,3526.468
lookup1,count(l.a),ten,4444.535,3102.161,3382.259
lookup1,count(l.a),one,4503.882,3145.432,3462.072
lookup1,'*',thousand,7869.671,4281.352,4492.678
lookup1,'*',hundred,5750.325,4321.32,4548.6
lookup1,'*',ten,5554.401,4128.838,4337.956
lookup1,'*',one,5724.242,4309.074,4479.229
lookup100,count(*),thousand,140825.205,51658.594,51910.674
lookup100,count(*),hundred,140918.236,51365.583,51559.118
lookup100,count(*),ten,128410.287,46405.746,46593.886
lookup100,count(*),one,140432.641,51141.736,51354.441
lookup100,count(l.a),thousand,143633.907,69384.23,66504.378
lookup100,count(l.a),hundred,143877.89,68809.635,65981.69
lookup100,count(l.a),ten,131145.929,62163.477,59541.391
lookup100,count(l.a),one,143358.858,68678.546,65701.101
lookup100,'*',thousand,256937.399,156422.443,154745.273
lookup100,'*',hundred,253973.453,153069.8,152742.719
lookup100,'*',ten,231615.463,139033.321,139677.871
lookup100,'*',one,255409.805,154030.921,153737.083