Home » Server Options » Replication » Usage of Materialized View
Usage of Materialized View [message #30239] Tue, 20 April 2004 15:05 Go to next message
Messages: 70
Registered: October 2000
HI, I have a script which is having 6 cursors. We have a specific cursor which is taking a long time to fetch the value from the production database. It is taking around 13 hours to fetch the output.

     We have checked the explain plan details for the above query and it is properly hitting the index.

Could any one of us suggest whether the usage of materialized view will have an enormous increase in performance.If it is true, please let us know how to use the materialized view instead of cursor??

SO we just need to know your suggestion on using the materialzed views under the above scenario.


Thanks and Regards/Saravanan.S





Re: Usage of Materialized View [message #30328 is a reply to message #30239] Fri, 23 April 2004 22:41 Go to previous message
Messages: 39
Registered: June 2002
Materialized views are not an alternative to cursors
Previous Topic: concurrent update, data recovery, and security
Next Topic: replication pack. error
Goto Forum:

Current Time: Fri May 20 15:51:40 CDT 2022