Loading

Execution plan saved for LINQ compiled queries?

James Sneeringer

18y5.2kLINQ

Does using compiled queries mean that the SQL Server execution plan is only created once, as is true for a stored procedure? Will the execution plan be re-created each time CompiledQuery.Compile() is called and only then?

I am finding apparently conflicting answers on different sites, and I would like to know for sure.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Bechir Bejaoui18y ago
Keep in mind one thing, is simply the fact that when you use the compiledQuery class, the parsing and the creation of the query is not repeated every time the same query is resuested even with different parameters