>>That's what I expected, but was hoping for confirmation. If the UDF performs a query, it may be better to do the UDF's query as a derived table?
>
>It may be better as derived table because SQL Query optimizer will treat it as one query and may come up with better execution plan.

That also fits my assumptions.