[dba-SQLServer] Views versus derived tables versus table UDFs

Arthur Fuller fuller.artful at gmail.com
Mon Jun 30 07:23:16 CDT 2008


Does anyone have any opinions on the performance of views versus derived
tables versus table UDFs? I've been looking at some of the code here at my
new job and I see some pretty extensive use of derived tables. In the past,
I have always used views or table UDFs for such operations, pretty much
because it simplified  the code, rather than because I did performance
checks.

TIA,
Arthur



More information about the dba-SQLServer mailing list