View vs Table-valued functions. Performance Analysis

[Syed Mehroz Alam]

Hi all, I am confused in choosing between a View and a table-valued UDF and looking for your suggestions. Here is what I want to do.

Select
Column1, Column2, .. ColumnN
From
Table1
Inner Join Table2 on SomeColumns
Inner Join Table3 on SomeColumns
..
Inner Join TableN on SomeColumns
Where
Condition1 ..... Condition N

Of course, I will be consuming this view/UDF in my queries later. Please note that I have no specific parameters for this query, nor have I any security requirements. I just want to know which one gives better performance. Ideas:confused: Thanks, Mehroz