Re: Poor plan when using EXISTS in the expression list

2018-10-04 Thread Pierre Ducroquet
On Thursday, October 4, 2018 4:46:26 PM CEST Geoff Winkless wrote: > On Thu, 4 Oct 2018 at 13:11, Pierre Ducroquet wrote: > > Our developpers ORM (Django's) sadly can not use EXISTS in the where > > clauses > > without having it in the expression part of the SELECT statement. > > I don't know if

Re: Poor plan when using EXISTS in the expression list

2018-10-04 Thread Geoff Winkless
On Thu, 4 Oct 2018 at 13:11, Pierre Ducroquet wrote: > Our developpers ORM (Django's) sadly can not use EXISTS in the where > clauses > without having it in the expression part of the SELECT statement. > I don't know if this will be helpful to you (and I appreciate there's still the underlying P

Poor plan when using EXISTS in the expression list

2018-10-04 Thread Pierre Ducroquet
Hello Our developpers ORM (Django's) sadly can not use EXISTS in the where clauses without having it in the expression part of the SELECT statement. I was expecting it to create queries performing a bit worse than queries without this useless expression, but it turns out this trigger an extremel