Coming soon: We’re working on a brand new, revamped Community experience. Want to receive updates? Sign up now!
The simple answer to that is maybe not to use a materialized view :
If for some optimisation reason you still want to use a materialized view, you can do the following :