Oracle materialized view support
16
votes
![](https://secure.gravatar.com/avatar/4281c7dd8a4c7d13e3267e671bb90577?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
The support for materialized views is implemented in the 8.5.464 build of dotConnect for Oracle.
-
Rob commented
Currently, without native support for materilaized views, the work around is to create a view with the same name and structure, add it to the model, drop it from the database and the recreate it as a materilaized view. This is time consuming, especially early on in the design phase when the design can change quite frequently.