<div>
I don't think there will be any noticable difference between the two in such a simple application. &nbsp;I would recommend using a view.
</div>


I don't think there will be any noticable difference between the two in such a simple application.  I would recommend using a view.

<div>
<div class="content wysiwyg-content">
Would you please tell me which one is faster between view and stored procedure? This is just for returning 1 single record in joined tables in a database<br />
<br />

</div>
</div>


Would you please tell me which one is faster between view and stored procedure? This is just for returning 1 single record in joined tables in a database



View and stored procedure, which one is faster

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.