84 What is a materialized view in sql server

preview_player
Показать описание
what is a materialized views in sql server

what is a materialized views in sql server
What is difference between views and materialized views?
Why do we use materialized view?
What is the equivalent of materialized views in SQL Server?

Рекомендации по теме
Комментарии
Автор

Can you explain what does 'schemabinding' do and create index do with respect to materialized view? Is there a way to see the data is getting from the stored db instead sql query? Does this not cache?

OneNI
Автор

Really it's well explained. Thank u.Please show some scenarios where materialized view used over normal view.

ipsitapradhan
Автор

Hi Aqiul! Good explanation. I have one doubt. If we have any changes in base tables it will be affect automatically in view?

rajinipraba.k