I have a Schema Bound View(say SC_View) which in internally uses union of around 10 other Schema bound viewes(say VW1,VW2...). The SC_VIEW uses noexpand hint for the inner views.
My problem is I cannot define an index in the SC_View as i use union and i suspect a performance degrade while querying this view. i want to know how the schma bound view with out an index affects the performance? Thanks for all your inputs
schema bound view with out an index doesn't improves the performance. what you have is just a standard schema bound view, which has all features of schema bound functionality, but as no index is defined there isn't any performance gain.Cheers!!!
SqlFrenzy
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Nested Views with schema binding
.png)
