84 What is a materialized view in sql server

what is a materialized views in sql server
Download the scripts used in the video from here: drive.google.com/drive/folder...
SQL Server tutorials: • SQL tutorial for begin...
SQL Server Developer Interview questions: • Sql server developer i...
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?
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@OneNI83]

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?

[@rajinipraba.k2125]

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

[@learnssis]

yes it will automatically update the view.

[@ipsitapradhan1672]

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

[@learnssis]

Thank you, will try to make such video.