Table-value function performance
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Can anyone comment on the performance pros/cons of using table-valued functions vs. Stored Procedures in SQLServer? Specifically: 1) are the execution plans for the functions stored as they are in stored procedures? 2) When using table variables inside the function, does the entire result set automatically wind up in memory, or can it be streamed using a reader? Thanks for any input.