postgresql-no-left-join-on.sql

create table t1 (
  key1 int,
  col1 int
);
insert into t1 select a, a from one_m;
create index t1_key1 on t1(key1);

create table t2 (
  key1 int,
  col1 int
);
insert into t2 select a, a from one_m;
create index t2_key1 on t2(key1);
analyze;

explain SELECT * FROM 
  t1 LEFT JOIN t2 on (t1.key1<100 AND t2.key1=t1.col);

explain
select * 
from t1 inner join t2 on (t1.key1<100 and t2.key1=t1.col);