Rewrite of costly CREATE VIEW statement
Hello,can any of you advise on if there is a more efficient way to create the view below.
I assume that it's possible to rewrite the query with inline sub-selects but I'm not sure if this will improve the performance of the statement.
These five cartesian product joins on table pa_parameter don't strike me as the best way to do this, though.
Needless to say, that I'm just the DBA - so I usually avoid rewriting queries for my developing colleagues or I would end up doing nothing else.
In this case I told them the "Ok, I'll see what I cand do", though.
I assume that it's possible to rewrite the query with inline sub-selects but I'm not sure if this will improve the performance of the statement.
These five cartesian product joins on table pa_parameter don't strike me as the best way to do this, though.
Needless to say, that I'm just the DBA - so I usually avoid rewriting queries for my developing colleagues or I would end up doing nothing else.
In this case I told them the "Ok, I'll see what I cand do", though.
0