Home » RDBMS Server » Performance Tuning » materialized view
materialized view [message #64970] Fri, 19 March 2004 10:53 Go to next message
Rock
Messages: 18
Registered: February 2002
Junior Member
can someone tell me whether there would be any performance impact on the base table of a materialized view while doing insert operation. I'm planning to create a mat. view on the table which will consists of few aggregations and case statements on the base table. can someone suggest a good website for performance tuning with materialized views

Thanks

Rock

 
Re: materialized view [message #64974 is a reply to message #64970] Sun, 21 March 2004 23:48 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

It all depend on the type of MView u r going to create. It u r going to create a MView with complete refresh option than there would not be any effect on the base table, but if u r planning to create a refresh fast MView than it will effect a little, Bcz in that case u have to create a Materialized view Log on the table which will get updated every time whenever u perfrom any DML on the base table.

Except that no other performance issue is there on the base table. And it really doesn't matter whether u use any aggregate query or simple one. It just effect the refresh time of MView.

Daljit Singh.
Previous Topic: Memmory
Next Topic: Delete statement takes a very long time
Goto Forum:
  


Current Time: Tue Sep 29 07:04:06 CDT 2020