Re: Throwing unnecessary joins away

=?ISO-8859-1?Q?Ott=F3_Havasv=F6lgyi?= <havasvolgyi.otto@gmail.com> writes:
> As far as I know SQL Server has some similar feature. It does not join
> if not necessary, more exactly: if the result would be the same if it
> joined the table.

I find it really really hard to believe that such cases arise often
enough to justify having the planner spend cycles checking for them.

            regards, tom lane