SQL Server: Is it faster to retrieve or filter data from views using stored procedure than getting or filtering data from tables using stored procedure?

Question

Hi, are there performance issues when retrieving and filtering data from views than from tables by using a stored procedure?

Simplification: Is it faster to retrieve or filter data from views using stored procedure than getting or filtering data from tables using stored procedure?

Answer 1

Simple answer: No.

Answer 2

The performance of a view depends on the performance characteristics of the select statement that defines it. You could improve performance over just the select itself by indexing the view