Hi all, I'm on APEX 21.2.0.
I have an interactive report based on a sql query.
Before the interactive report in the page, I have some items that I use for filter data (these fields are requirements from my users) and a button "Find data" that simply submit the page so that I retrieve data from table using filter fields.
This is the query of my interactive report:
select ROWID, YEAR, MONTH, VALUE, FIELD5, FILED6, FIELD7....
from MYTABLE
where YEAR = nvl(:P1_YEAR, YEAR )
and MONTH = nvl(:p1_MONTH, MONTH)
and VALUES = nvl(:p1_VALUE, VALUE) ;
Some of my filter fields are not required, for this reason i have used the NVL function.
My goal is to reduce time for retrieving data from this SQL query.
Is there something to substitute NVL function to increase performance of retrieving data?
Thanks all for collaboration.
Fabrizio