I realize this is a little random, but DB2 (circa V8) had a feature to define tables from the CREATE VIEW syntax. Basically, the view was saved to disk to save the cost of recreating the dataset each time the view is called.
All I really need to know is what was this feature called? I was thinking it was Federated Views, but that seems to be about incorporating external data into the database. Would this work for saving aggregated data from within a database or is there another name for this feature?
Please help an old guy out.
Best Answer
You're thinking of Materialized Query Tables or MQTs. They are still part of the product, see this documentation.