Re: [Cloud] Another SQL optimization request

> Finally, any advice on how to make it more efficient is highly appreciated. I would be more concerned about the derived subquery, as that can create many executions of the inside query for every row of the outside one. If you could update the query with a comprehensive comment of what you are t

Re: [Cloud] Another SQL optimization request

It looks to me like the query attempts to count all logged-in non-bot page creations in certain namespaces, grouped by user, and each user also has their counts for the various different individual namespaces shown. On Wed, 5 Jun 2019 at 09:53, Jaime Crespo wrote: > > Finally, any advice on how

Re: [Cloud] Another SQL optimization request

Alex is correct. The goal of the query is to generate a table like this