subramaniam.chandrasekar - Wednesday, February 7, 2018 12:53 AM
I have a very hard time believing that a view improved performance unless it was an Indexed View. A normal view is just an encapsulation of a query as if you wrote the query in a FROM clause or in a CTE. Can you site any article or post any demonstrable code that proves that a normal view offers any type of a performance improvement?
--Jeff Moden
Change is inevitable... Change for the better is not.