starjoin.sql

application/sql

Download

\set id random(1,10000)

-- set join_collapse_limit = 1;
-- set join_collapse_limit = 12;
-- set enable_starjoin = on;

explain select * from f
  join d0 on (d0.id = f.id0)
  join d1 on (d1.id = f.id1)
  join d2 on (d2.id = f.id2)
  join d3 on (d3.id = f.id3)
  join d4 on (d4.id = f.id4)
  join d5 on (d5.id = f.id5)
  join d6 on (d6.id = f.id6)
  join d7 on (d7.id = f.id7)
  join d8 on (d8.id = f.id8)
  join d9 on (d9.id = f.id9)
where f.id = :id;