Clones of materialized views can be created directly by the user.

Multiple tables can be joined in the underlying query of a materialized view.

Aggregate functions can be used as window functions in materialized views.