Which is faster ? View or Stored procrdeure

Question

Let's say we have we simple query to get data from a table.

select firstname from Customer

We have a View with this query and stored procedure .

Which is faster and why ?

Answer 1

I would expect identical performance with either a view or stored procedure because the query execution plans will likely be the same. Views and procedures are different from a functionality perspective, though, so you may see differences in performance for more complex scenarios but I wouldn't generalize one will be faster than the other.