Tune and optimize SQL on very complex view: could be procedural solution to the view definition than
Hello collegues,
One of our developer has very complex view on which the cost of SQL query in performance and system load is more and more complex with the raise of rows.
SQL query is almost ideal for master-detail-detail problem.
TableA -> ViewB -> ViewC.
The problem is that ViewB is union of two tables.
And so as ViewC is union of two tables and aggregated with group by operation and sum columns to the same level as ViewB.
But it is also the union of two tables.
I wonder if there is any Oracle pl/sql or procedural technology where istead of declarative SQL query with union solution I could implement procedural solution with using
One of our developer has very complex view on which the cost of SQL query in performance and system load is more and more complex with the raise of rows.
SQL query is almost ideal for master-detail-detail problem.
TableA -> ViewB -> ViewC.
The problem is that ViewB is union of two tables.
And so as ViewC is union of two tables and aggregated with group by operation and sum columns to the same level as ViewB.
But it is also the union of two tables.
I wonder if there is any Oracle pl/sql or procedural technology where istead of declarative SQL query with union solution I could implement procedural solution with using
0