Recently I've started to analyze execution plans. Today I stumbled on an execution plan that has no
ParameterCompiledValue (and no
It is a plan of a select with one inner join and seven left outer joins.
Is there a reason why some execution plans have a
ParameterCompiledValue and others don't?
Is it correct to stay the ParameterList is empty due to the fact that sql server could not sniff the parameters? It is not an ad-hoc query and is exectued by a third party c# application. The query and queryplan can be found on Google drive