Questions tagged [trivial-plan]

For SQL Server execution plans that are marked as Trivial

Filter by
Sorted by
Tagged with
8
votes
1answer
260 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 ...