Re: How to optimizate COUNT query with multiple LEFT JOIN
To spare us the ads, the readability issues, and the risks inherent in links of unknown provenance, please post the Explain result here inside BBCode code tags.
1 sec isn't bad for aggregation over a dozen joins. (Why would market research require blazing speed?)
Why Left Joins? Your Where conditions turn them into implicit Inner Joins, and Inner Joins benefit more from covering indexes, which might help fractionally.
Subject
Views
Written By
Posted
588
June 01, 2021 01:19AM
284
June 01, 2021 01:31AM
Re: How to optimizate COUNT query with multiple LEFT JOIN
295
June 01, 2021 12:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.