(1) T1 inner join T2 using (c1, c2)
(2) T1 left join T2 using (c1, c2) where c2 is not null Thanks, -- Lu Ying -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Two tables, each contains more than hundreds of thousands records. Is
there any efficiency differences between (1) and (2)?
- [SQL] left join where not null vs. inner join Emi Lu
