I have read at least one post by Grant Fritchey stating that the optimizer can have issues when joining views to views. I've no doubt that he is correct, but was just wondering if others can confirm this to be an issue, and if there is a specific set of circumstances that makes it happen.
I've recently taken hold of an application where view-to-view joins occur everywhere. There are numerous performance problems with this system, and this is just one potential facet. I'm trying to prioritize my approach to dealing with the sluggish-ness of the system.
Thanks in advance --