phosplait (1/4/2016)
which I did not include initially because I didn't want it to distract from the question of why the TVP operations had such a high cost.
These types of issues are tough to figure out on our own systems where we have access to everything, so handicapping us here will not help.
Looking at this and the list of parameters in this as found in the attached plan,
select * from Object1(?,?,Variable2,Variable3,Variable4,Variable5,?,Variable6,
Variable7,Variable8,Variable9,Variable10,Variable11,Variable12,Variable13) where Column1 is not null option(recompile)
I cannot see how the TVF is related to the query from the plan attached as they have differing parameter definitions.
The TVF initially has a table as a parameter.
The query from the plan has a list of variables and not a table.
There are a total of 10 tables in the plan, but the attached TVF only has 3.
Handicapped.