04 – Trivial Plans (17m)

When SQL Server thinks your query will be trivially simple to execute, it bails out of query optimization early on, without going through the full depth of tuning options available. Let’s cover what plans generally qualify as trivial, what makes a plan go beyond trivial, simple parameterization, and how to tell when your query plan...