do unneeded outer joins cost? - Mailing list pgsql-sql

From chester c young
Subject do unneeded outer joins cost?
Date
Msg-id 886808.30289.qm@web54302.mail.re2.yahoo.com
Whole thread Raw
Responses Re: do unneeded outer joins cost?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
for example:

select    t1.*
from      t1
left join t2 on( <expensive condition> );

since t2 is not used in the result nor is it used in determining the result, is the <expensive condition> to left join
t2used?
 

(the question goes as to how much generated sql needs to be cleaned to be efficient)


     


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Type inheritance
Next
From: Gianvito Pio
Date:
Subject: Re: Type inheritance