On Wed, Oct 25, 2023 at 1:31 PM David Rowley wrote:
>
> On Wed, 25 Oct 2023 at 22:59, Alexander Korotkov
> wrote:
> > src/test/regress/sql/join.sql | 359
>
> There seems to be a few EXPLAINs added here that didn't include costs off.
Thank you for catching this. Fixed.
On Wed, 25 Oct 2023 at 22:59, Alexander Korotkov
wrote:
> src/test/regress/sql/join.sql | 359
There seems to be a few EXPLAINs added here that didn't include costs off.
David
Remove useless self-joins
The Self Join Elimination (SJE) feature removes an inner join of a plain table
to itself in the query tree if is proved that the join can be replaced with
a scan without impacting the query result. Self join and inner relation are
replaced with the outer in query, equiva