3 ms·
Isn't an mssql indexed view essentially a materialized view? Postgres also supports indexes on materialized views.
by shawnz 7y ago
Isn't an mssql indexed view essentially a materialized view? Postgres also supports indexes on materialized views.
- dragonwriter 7y agoAn MSSQL indexed view is like a materialized view, except it's not actually materialized beyond the index, as I understand it, and there are restrictions on the view definition that mat views don't have, and it updates automatically.