Table Valued Function where did my query plan go?

Multi-statement table valued functions (TVF) are black boxes to the optimiser for the outer query. You can only see IO, CPU etc from profiler The TVF must run to completion and return all rows before any processing happens. That means a where clause will not be optimised for example So if this TVF returns a million rows, it has be sorted first SELECT TOP 1 x FROM db.

MyTVF ORDER BY x DESC Single statement/inline TVFs do not suffer because they are expanded like macros and evaluated. The example above would evaluate indexes etc Also here too: Does query plan optimizer works well with joined/filtered table-valued functions? And Relative Efficiency of JOIN vs APPLY in Microsoft SQL Server 2008 To answer exactly: no, no, and no I have very few multi statement TVFs: where I do, I have lots of parameters to filter inside the UDF.

Multi-statement table valued functions (TVF) are black boxes to the optimiser for the outer query. You can only see IO, CPU etc from profiler. The TVF must run to completion and return all rows before any processing happens.

That means a where clause will not be optimised for example. So if this TVF returns a million rows, it has be sorted first. SELECT TOP 1 x FROM db.

MyTVF ORDER BY x DESC Single statement/inline TVFs do not suffer because they are expanded like macros and evaluated. The example above would evaluate indexes etc. Also here too: Does query plan optimizer works well with joined/filtered table-valued functions? And Relative Efficiency of JOIN vs APPLY in Microsoft SQL Server 2008 To answer exactly: no, no, and no I have very few multi statement TVFs: where I do, I have lots of parameters to filter inside the UDF.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.