A few key differences is listed here
a) View can be materialized (indexed view) and hence performs better. But Inline Table Valued functions cannot be indexed and performance decreases when number of rows increases.
b) Views can have triggers since they can be used to change underlying tables (INSTEAD OF triggers) but not Inline Table Valued functions.
c) We can use CROSS APPLY with the Inline Table Valued function but not with a view.
d) Views don't accept parameter but Inline Table Valued function does so.
Asked In: Many Interviews |