| Subject | Materialized views |
|---|---|
| Author | |
| Post date | 2014-06-07T12:36:02Z |
Is there a plan to add materialized views in version 3.0
If not, which would be the workaround to do it in Firebird 2.5 without using triggers? Basically I would need to update the materialized views once each 2-3 days, so probably using a stored procedure would be enough. I thought using a INSERT SELECT way, but I am not clear how to create the table scheme from the view using DDL. I update the view scheme sometimes, so I would prefer to recreate the new table scheme each time that I would need to create the "materialized" view.
Thank you
If not, which would be the workaround to do it in Firebird 2.5 without using triggers? Basically I would need to update the materialized views once each 2-3 days, so probably using a stored procedure would be enough. I thought using a INSERT SELECT way, but I am not clear how to create the table scheme from the view using DDL. I update the view scheme sometimes, so I would prefer to recreate the new table scheme each time that I would need to create the "materialized" view.
Thank you