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.