Re: Better way to write this query?
Posted by:
Ben D
Date: June 02, 2021 04:59PM
Hi Peter,
Thank you for fixing the formatting on this. I will make sure I remember that BBCode tags work here.
I appreciate the links you sent, it's some helpful reading.
I decided to create a "flat" table to keep track of what I need to for reporting purposes. I feel like it's a lot less to maintain since I can update the table in real time with the data I need and then when anyone is viewing a report that needs to see this data, I'm only retrieving one row with the columns needed.
This report is already doing A LOT and to be honest could probably use a re-write. It's one of those situations where it was intended to be small but then over time we just keep adding more and more to it.
Thanks again for looking at my mess of an explanation so quickly.
Much appreciated,
Ben
Subject
Written By
Posted
Re: Better way to write this query?
June 02, 2021 04:59PM
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.