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.
JyozealAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
If the View doesn't have an index why are you calling it Indexed View?
It's only a Schemabinding View.
0
 
Alpesh PatelAssistant ConsultantCommented:
You can create Clustered index on schema binding view.

https://msdn.microsoft.com/en-us/library/ms191432.aspx
0
 
lcohanDatabase AnalystCommented:
https://technet.microsoft.com/en-us/library/ms187864(v=sql.105).aspx

"...you can improve performance by creating a unique clustered index on the view. When a unique clustered index is created on a view, the result set is stored in the database just like a table with a clustered index is stored. "

So your view without a clustered index is like any regular SQL view except is with SCHEMABINDING so underlying table columns can't be dropped for instance as they are referenced in this view..
0
 
JyozealAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.