5 ms·

> Are things like "a materialized view (1996!), a continuous query, the result cache" available in any free DBs nowadays? Getting there... http://www.postgresq

by __alexs 13y ago

> Are things like "a materialized view (1996!), a continuous query, the result cache" available in any free DBs nowadays? Getting there... http://www.postgresql.org/docs/9.3/static/rules-materializedviews.html http://www.postgresql.org/docs/9.3/static/rules-materialized... (The rest of his examples are complicated Oracleisms and you'd probably get pretty far with MVs.)

omarqureshi 13y ago
9.3 matviews are a step forward, yet you could probably roll your own matviews with triggers.
- 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 ago
    I 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.