Home » Developer & Programmer » Data Integration » Query rewrite and changing sql conditions
Query rewrite and changing sql conditions [message #93338] Fri, 30 July 2004 11:38
Jaya Krishnan
Messages: 1
Registered: July 2004
Junior Member
We have a complex query to support a reporting requirement using a reporting tool called business objects.  The Report has several prompts, which will be used to filter the data.  (The Report prompts will be applied as filter condition in the query sql statement with the coition entered by the users at the report runtime.)


As the report performance is bad, we plan to create a materialized view to improve the report performance. Since there are a number of filter conditions which will be applied dynamically to the query sql, how to create a materialized view and enable query rewrite to support this.
Previous Topic: ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []
Next Topic: Oracle Warehouse Builder and Workflow 2.6.2 on linux
Goto Forum:

Current Time: Mon Oct 26 02:59:51 CDT 2020