which is faster views or stored procedure? asp.net sql server

Question

Hi Everybody, i want to know whether views or stored procedures are faster. i am developing application in asp.net with sql server. Which one should i use for good performance of asp.net application. Thanks

Answer 1

They should perform equally well.

Without more info it is pretty hard to tell.

Also out of curiosity why you are not using any indexes ?

Answer 2

I assume that you want to use only sql query in your SP/View with no extra T-Sql logic. SPs are precompiled so here you might gain some advantage especially if business logic is coded in there. Views you can index and gain significant performance but to do that you have to use schema binding, then it becomes materialized view. You can read more on indexing views here