I've heard a lot of pros and cons about using views. This question is specifically related to one project that has 36 views. The views are killing performance. The complexity of some of the views makes it very difficult to make changes. The problem is that some of our views break in the query builder because of the complexity. Now we've got to maintain that code outside of the builder.

I've used a lot of views and like the simplicity of the updatable parameterized views. I was curious if anyone had some approaches to the above problems that would ease some of the maintenance and performance headaches. Perhaps we've gone the wrong way and we should not even been using views.

Any thoughts and suggestions you have in this regards would be greatly appreciated.

Dan