Sv: Re: Re: Removing INNER JOINs

På fredag 01. desember 2017 kl. 03:53:29, skrev David Rowley < david.row...@2ndquadrant.com >: On 1 December 2017 at 15:34, Andreas Joseph Krogh > wrote:  Can someone please explain, in layman-terms, what the

Re: Re: Removing INNER JOINs

On 1 December 2017 at 15:34, Andreas Joseph Krogh wrote: > > Can someone please explain, in layman-terms, what the problems with FKs > are related to JOIN-removal? > Pretty much what I just wrote after "Unfortunately not," above, although you asked a few seconds before I

Sv: Re: Removing INNER JOINs

På fredag 01. desember 2017 kl. 03:30:21, skrev Simon Riggs < si...@2ndquadrant.com >: On 1 December 2017 at 12:20, David Rowley wrote: > On 1 December 2017 at 02:52, Andreas Joseph Krogh wrote: >> >> I came

Re: Removing INNER JOINs

On 1 December 2017 at 15:30, Simon Riggs wrote: > On 1 December 2017 at 12:20, David Rowley > wrote: >> The large hurdle which a good workaround was never really found for >> was the fact that foreign key triggers only update the referenced

Re: Removing INNER JOINs

On 1 December 2017 at 12:20, David Rowley wrote: > On 1 December 2017 at 02:52, Andreas Joseph Krogh wrote: >> >> I came across this from Oracle: >> https://oracle-base.com/articles/misc/join-elimination#basic-join-elimination >> >> Needless to

Sv: Re: Removing INNER JOINs

På fredag 01. desember 2017 kl. 02:20:19, skrev David Rowley < david.row...@2ndquadrant.com >: On 1 December 2017 at 02:52, Andreas Joseph Krogh wrote: > > I came across this from Oracle:

Re: Removing INNER JOINs

On 1 December 2017 at 02:52, Andreas Joseph Krogh wrote: > > I came across this from Oracle: > https://oracle-base.com/articles/misc/join-elimination#basic-join-elimination > > Needless to say, this would be very cool to have in PG:-) It would be nice, I agree. > It seems