Questions tagged [trivial-plan]

For SQL Server execution plans that are marked as Trivial

Filter by
Sorted by
Tagged with
10 votes
1 answer
611 views

Why does a plan with FULL optimization show simple parameterization?

I read that only Trivial Plans can be Simple Parameterized, and that not all queries (even when the plan is Trivial) can be Simple Parameterized. Then why is this plan showing Full Optimization, and ...
Erik Darling's user avatar
  • 40.6k