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

small UDF tables are fast.. so there is not much of a performance hit since
most of the data is loaded to RAM, but if you are dealing with thousands of
rows then you will want to re-do those UDFs as sprocs or Views if possible
:) imho



On Mon, Jun 30, 2008 at 5:23 AM, Arthur Fuller <fuller.artful at gmail.com>
wrote:

> 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
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
-Francisco
http://sqlthis.blogspot.com | Tsql and More...