I have a query that is used in a BIRT report (in IBM's Maximo Asset Management platform).
I'm considering storing the query in a materialized view in order to improve performance and reduce the load on the system.
Is a way to deliberately make the report fail if the MV is out-of-date?
- In other words, we'd rather have no data in the report, than wrong data.
I removed the excessive details from the question.