OraFAQ Forum: Data Integration » Query rewrite and changing sql conditions

Home » Developer & Programmer » Data Integration » Query rewrite and changing sql conditions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Previous Topic:	ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []
Next Topic:	Oracle Warehouse Builder 9.2.0.2.8 and Workflow 2.6.2 on linux

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 03:23:43 CST 2024