easy5 pts · first answer countssqlpostgresql

View vs materialized view

What is the difference between a normal view and a materialized view in PostgreSQL?

A.A normal view stores its rows on disk; a materialized view runs the query every timeB.They are identical; materialized is just an aliasC.A normal view runs its query each time it is used; a materialized view stores the result and must be refreshedD.A materialized view can only be used by superusers

← What pg_hba.conf controls What ROLLBACK undoes →