The more work you can lift off those outermost views the better. That's what I mean by materializing the inner views. Views referencing views that reference base tables are bad enough. If your view hierarchy is deeper than even a simple two levels then you may need to rethink what's happening. I might suggest you move in the direction of converting some of these views to stored procedures or inline-table-valued functions and get out of the business of using views.