GilaMonster (1/9/2015)
jeffem (1/8/2015)
using multiple views is very often going to include tables that aren't at all necessary to the core logic of what you're trying to accomplish.Depending on the view (especially on whether there's aggregation), the T-SQL parser can eliminate unnecessary views as part of it's simplification process. However that takes time and it's easily possible for nested views to have parse times > execution times if the parser has to do a lot of repeated view inlining and simplification.
Thanks, Gail! Very good to know. I was initially only thinking of a scenario using portions of all views involved but some tables from each view unnecessarily included and hadn't considered unnecessary views being eliminated. Smart!