But you are using SQL Server, whereas most of my clients use VFP tables. I have never really run into a performance issue with VFP. All my apps a very fast due to the proper optimization. It's starting to sound like you have a bias against parameterized views. Anything can be made to perform poorly - even SPT.

>Depends on the view and the parameters: http://msvfp.advisorguide.com/doc/16302
>
>SPT with dynamically constructed ad-hoc parameterized where clauses is IMO the ultimate in control for me as a developer, flexibility for the user, performance and safety.