For SQL Server execution plans that are marked as Trivial
Trivial plans are typically low cost affairs, with no joins, subqueries, or other cost-based decisions to make, particularly around index choice.
Trivial plans do not undergo full optimization, may not produce missing index requests, and may bypass Foreign Key join elimination, and Constraint contradiction detection.
