Re: Very slow Query compared to Oracle / SQL - Server

Subject: Re: Very slow Query compared to Oracle / SQL - Server
From: didier <did447@xxxxxxxxx>
Date: Sat, 8 May 2021 00:17:02 +0200
Cc: Semen Yefimenko <semen.yefimenko@xxxxxxxxx>
In-reply-to: <CAH2-WznBogckHqgW3gVVDn=k=rgKhfFpEkQZ-=L=7p2QKTjpPQ@mail.gmail.com>
References: <CAKnyMoKUUSPiH=0QaM38GYm8UqVeR47HmX+MX+UpyL0mLERBrw@mail.gmail.com> <CAJnEWwmJg1aUbv5h2zsuWD2i0K-Jc052TTCGAspwv2BYejH3xQ@mail.gmail.com> <CAKnyMo+fqJk+0ASfonf4sLghr3R66FyFV5y1tv6tUh4SHKyykg@mail.gmail.com> <CAM+6J97Rcg3XOLjSoC0XXyA4SW=gqSzBJQQsGXwo1r2=5bcRGg@mail.gmail.com> <CAKnyMoKp9Mck1A2La+mcrwto9+T72ieUOc2Ubfr5C0VhcRAPHw@mail.gmail.com> <CAM+6J96ybUF4=bxh1Mc9VnYXfiJyZiHM_YxpasdF86cRHQMvAA@mail.gmail.com> <CAKnyMoJb=+hBwOG97zd2Jbumg1BZuYpEqTPWStaFFNmfArBvQA@mail.gmail.com> <20210507161551.GT27406@telsasoft.com> <CAH2-WzkU47Z1pu=ODC0kwADW3nEycng2zw-u+GasnW8px5g-bw@mail.gmail.com> <CAH2-WznBogckHqgW3gVVDn=k=rgKhfFpEkQZ-=L=7p2QKTjpPQ@mail.gmail.com>

Are you sure you're using the same data det ?

Unless I'm overlooking something obvious one result has 500 000 rows the other 7 000.

Follow-Ups:
- Re: Very slow Query compared to Oracle / SQL - Server
  - From: Semen Yefimenko

References:
- Very slow Query compared to Oracle / SQL - Server
  - From: Semen Yefimenko
- Re: Very slow Query compared to Oracle / SQL - Server
  - From: Imre Samu
- Re: Very slow Query compared to Oracle / SQL - Server
  - From: Semen Yefimenko
- Re: Very slow Query compared to Oracle / SQL - Server
  - From: Vijaykumar Jain
- Re: Very slow Query compared to Oracle / SQL - Server
  - From: Semen Yefimenko
- Re: Very slow Query compared to Oracle / SQL - Server
  - From: Vijaykumar Jain
- Re: Very slow Query compared to Oracle / SQL - Server
  - From: Semen Yefimenko
- Re: Very slow Query compared to Oracle / SQL - Server
  - From: Justin Pryzby
- Re: Very slow Query compared to Oracle / SQL - Server
  - From: Peter Geoghegan
- Re: Very slow Query compared to Oracle / SQL - Server
  - From: Peter Geoghegan