Re: help improving 'join' efficiency in sub-querys
because each of these cases require me to look for the unique ID
where d2.id = frm_grp.id and frm_req.id = 335
in this case 335 will take me to the relevant data that I want to appear within the column.
If I was to move the joins into the main query, I would see an entry for each frm_req.id.
I initially thought of transposing the data however I am not sure if this is possible and additionally I do not know if I could filter out the ID's that are not required to be displayed.
Subject
Written By
Posted
September 15, 2016 07:43AM
September 15, 2016 12:13PM
Re: help improving 'join' efficiency in sub-querys
September 16, 2016 06:19AM
September 16, 2016 11:42AM
September 19, 2016 03:24AM
September 19, 2016 03:55AM
September 19, 2016 08:00AM
September 19, 2016 08:49AM
September 19, 2016 09:45AM
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.