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.
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.
Alpesh PatelAssistant ConsultantCommented:
You can create Clustered index on schema binding view.
lcohanDatabase AnalystCommented:

" 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..
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.
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.