4 ms·
9.3 matviews are a step forward, yet you could probably roll your own matviews with triggers.
by omarqureshi 13y ago
9.3 matviews are a step forward, yet you could probably roll your own matviews with triggers.
- inflagranti 13y agoThe nice thing with materialized views in DB2 for instance (don't know about oracle) is that they are automatically picked by the optimizer to replace a join. So your logical query is - as it should be - completely exasperated from the physical storage underneath. The DBA just puts in a materialized view and the application will speed up magically :)
- noelherrick 13y agoI think you mean "completely abstracted from the physical storage underneath" :) Although, I'm sure queries exasperate the storage all the time. Regardless, I had no idea DB2 was so smart. I guess you get what you pay for.