asked on indexed view creation
I came across code where indexed view was created with schema binding but no clustered indexes were created on it.
So how will SQL server treat this view? i assumed indexed view creation includes using Schema binding AND creating clustered index on the view.
Thanks for your time.
So how will SQL server treat this view? i assumed indexed view creation includes using Schema binding AND creating clustered index on the view.
Thanks for your time.
Microsoft SQL Server 2008Microsoft SQL Server 2005Microsoft SQL Server
Last Comment
Jyozeal
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Vitor Montalvão, i did not create the view. I am changing code written by somebody else. so trying to understand why they did so. I did not think of schema binding View because just that alone doesn't help in my scenario. Both your answers helped me. Thank you.
https://msdn.microsoft.com/en-us/library/ms191432.aspx