3 ms·
The 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. S
by inflagranti 13y ago
The 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.