I am using Oracle Reports Developer 10g and I wanted to know when the
the queries are fired from the data model. If there are more than 1 do
they run 1 at a time or do they run at the same time.
My purpose for asking this question is to speed up the report. After running a trace. I see there are 6 program units that return values base on the input prior to getting the counts and generating the page layout. My question is could I speed this up
by removing the plsql and replacing it in the sql with a decode?
Edited by: hh**** on Oct 4, 2012 3:07 PM