locked
Nested Views with schema binding RRS feed

  • Question

  • 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
    Tuesday, March 16, 2010 5:35 AM

Answers

  • 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
    Tuesday, March 16, 2010 12:25 PM