metatron-discovery icon indicating copy to clipboard operation
metatron-discovery copied to clipboard

Published 20 hours ago • verified publisher icon metatron-app

Reintroduce heuristic join reordering

Open navis opened this issue 2 years ago • 2 comments

Some improvement in plan (tpch-7, etc.)

navis avatar Sep 14 '22 08:09 navis 

tpch-1  = 1.659sec
tpch-2  = 1.338sec
tpch-3  = 1.534sec
tpch-4  = 0.883sec
tpch-5  = 1.096sec
tpch-6  = 0.715sec
tpch-7  = 0.456sec
tpch-8  = 0.462sec
tpch-9  = 2.733sec
tpch-10 = 0.121sec
tpch-11 = 0.238sec
tpch-12 = 0.217sec
tpch-13 = 2.132sec
tpch-14 = 0.192sec
tpch-15 = 0.329sec
tpch-16 = 0.666sec
tpch-17 = 0.107sec
tpch-18 = 7.966sec
tpch-19 = 0.452sec
tpch-20 = 0.246sec
tpch-21 = 11.061sec
tpch-22 = 0.642sec

tpch-3 = 0.473sec -> 1.534sec tpch-5 = 2.042sec -> 1.096sec tpch-7 = 3.069sec -> 0.456sec tpch-10 = 0.693sec -> 0.121sec

navis avatar Sep 15 '22 03:09 navis

fixed tpch-3

navis avatar Sep 15 '22 07:09 navis