Re: Query optimization needed
The query needs to look at 28 * 861502 * 180518 = 4.4 trillion rows. For the two biggest contributors, the engine can find no index. That's not going to work.
Left joins don't optimise well, and join conditions with ORs don't optimise at all. Can you move that filtering elsewhere? Prepare an intermediate result table? I would keep moving those forks back to a preprocessing stage till the query looks reasonable to Explain.
That first left Join involves a table with 800k rows. Can you do with Inner Joins?
Edited 1 time(s). Last edit at 11/08/2015 04:14PM by Peter Brawley.
Subject
Views
Written By
Posted
1880
November 05, 2015 01:42AM
Re: Query optimization needed
726
November 05, 2015 11:40PM
839
November 06, 2015 11:25PM
875
November 08, 2015 04:32PM
801
November 17, 2015 05:43AM
812
November 26, 2015 09:21PM
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.