It depends.
If you have a lot of selects on certain conditions, then a materialized view based on those conditions can increase performance for those selects.
On the other hand, materialized views, like any index, do slow down insert/update/delete operations.
In many cases, the slight slow-down on those is worth the large speed-up on selects, but this requires doing some research and making sure the view is exactly what you need.
Used correctly, a materialized view can speed up lots of things. Used poorly, they can slow down lots of things.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon