RE: Slow query with aggregate and many LEFT JOINS

2019-02-22 Thread Igor Neyman
From: kimaidou [mailto:[email protected]] Sent: Friday, February 22, 2019 10:37 AM To: [email protected] Subject: Slow query with aggregate and many LEFT JOINS Hi all, I need to optimize the following query http://paste.debian.

RE: Slow query with aggregate and many LEFT JOINS

2019-02-22 Thread Igor Neyman
From: kimaidou [mailto:[email protected]] Sent: Friday, February 22, 2019 10:37 AM To: [email protected] Subject: Slow query with aggregate and many LEFT JOINS Hi all, I need to optimize the following query http://paste.debian.net/hidden/ef08f864/ I use it to create a mater