TPC-H 10G Skew Factor Z=1 results
---------------------------------

LI-P Regular HJ: (time in milliseconds)
990344
1022562
1071250
1003219
1049000
989953
Average: 1021054.667


LI-P Skew-enabled HJ: (time in milliseconds)
883593
960860
934906
1007282
937406
948078
Average: 945354.1667

% Difference: 7.4%


LI-P
Values: 100 Skew: 0.27  Est. tuples: 59986052.00 Batches: 512  Est. Save: 16114709.99
Total Inner Tuples: 2000000
IM Inner Tuples: 83
Batch Zero Inner Tuples: 3941
Batch Zero Potential Inner Tuples: 3941
Total Outer Tuples: 59986052
IM Outer Tuples: 16074146
Batch Zero Outer Tuples: 98778
Batch Zero Potential Outer Tuples: 98778
Total Output Tuples: 59986052
IM Output Tuples: 16074146
Batch Zero Output Tuples: 98778
Batch Zero Potential Output Tuples: 98778
Percentage less tuple IOs than HHJ: 25.98



LI-P-S Regular HJ: (time in milliseconds)
1833016
1567515
1504625
Average: 1635052

LI-P-S Skew-enabled HJ: (time in milliseconds)
883593
1280297
1423984
Average: 1195958

% Difference: 27%

LI-S
Values: 100 Skew: 0.19  Est. tuples: 59986052.00 Batches: 32  Est. Save: 11097357.16
Total Inner Tuples: 100000
IM Inner Tuples: 78
Batch Zero Inner Tuples: 3123
Batch Zero Potential Inner Tuples: 3125
Total Outer Tuples: 59986052
IM Outer Tuples: 11563695
Batch Zero Outer Tuples: 1577432
Batch Zero Potential Outer Tuples: 1693632
Total Output Tuples: 59986052
IM Output Tuples: 11563695
Batch Zero Output Tuples: 1577432
Batch Zero Potential Output Tuples: 1693632
Percentage less tuple IOs than HHJ: 19.61

(LI-S)-P
Values: 100 Skew: 0.27  Est. tuples: 59986052.00 Batches: 512  Est. Save: 16114709.99
Total Inner Tuples: 2000000
IM Inner Tuples: 83
Batch Zero Inner Tuples: 3941
Batch Zero Potential Inner Tuples: 3941
Total Outer Tuples: 59986052
IM Outer Tuples: 16074146
Batch Zero Outer Tuples: 98778
Batch Zero Potential Outer Tuples: 98778
Total Output Tuples: 59986052
IM Output Tuples: 16074146
Batch Zero Output Tuples: 98778
Batch Zero Potential Output Tuples: 98778
Percentage less tuple IOs than HHJ: 25.98