I am guessing that this has been discussed already but I cannot seem to find any threads on the specific topic. I am trying to determine if there is reason to modify a bunch of store procedures that select rows from views. We have a large number of stored procedures that were generated via a DAL tool. The sp simply selects data from a view with a WHERE clause to filter the results. So the simple question is; is there a performance reason or best practice reason to NOT select data from views in stored procedures. I have ran some tests by substituting the reference to the view in the sp with the view's SELECT statement and there seems to be no difference in performance between the versions of the sp. However, it is possible that my tests are flawed in some way. Or is the SQL engine smart enough to merge the WHERE in the sp with the view's definition and not return all rows in the view before applying the selection criteria specified in the sp's WHERE clause? Thanks for any advise.