| materialized view [message #64970] |
Fri, 19 March 2004 10:53  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
