join_left_cbo.sql 220 B

123456789
  1. use plato;
  2. pragma warning("disable", "8001"); -- CBO_MISSING_TABLE_STATS
  3. pragma CostBasedOptimizer="PG";
  4. select i1.value, i2.value
  5. from Input1 as i1
  6. left join Input2 as i2 on i1.key=i2.key
  7. order by i1.value, i2.value;