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