Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

use dataverse tpch;

for $d in dataset Lineitem

for $t in dataset Orders
/*+ psort */

where 4 * $d.l_extendedprice - 4 * $t.o_totalprice > -2 and4 * $d.l_extendedprice - 4 * $t.o_totalprice < 2

return

{"ok": $d.l_orderkey, "ln": $d.l_linenumber, "ep": $l.l_extendedprice, "tp": $t.o_totalprice}


4.1 Five stages of parallel sort-based binary join

 

Image RemovedImage Added

 

 

4.2 Histogram merging based on the densities of the both sides.

...