Did that Query Eliminate Partitions? (videos)

Did that Query Eliminate Partitions? (videos)

By Kendra Little
1 min read
Category: query-performance
Tags: partitioning , execution-plans , partition-elimination
Did that Query Eliminate Partitions? (videos) 1 min read
Did that Query Eliminate Partitions? (videos)

Table partitioning makes execution plans a bit more confusing.

Free Course

I have a free online course which walks you through decoding execution plans, including whether or not partition elimination occurred.

RELATED POSTS

How to Filter RPC_Completed Events in Extended Events: SQL Server Guide

How to Filter RPC_Completed Events in Extended Events: SQL Server Guide

The rpc_completed event in Extended Events is useful when troubleshooting SQL Server performance. It captures detailed information about Remote …

Read More
Why Won't PostgreSQL Use My Covering Index?

Why Won't PostgreSQL Use My Covering Index?

Dear Postgres, Why won’t you use my covering index?

Lately I’ve been learning to tune queries running against PostgreSQL, and it’s …

Read More
Fixing OPTIMIZATION REPLAY FAILED in Query Store: When Plan Forcing Breaks in SQL Server 2022+

Fixing OPTIMIZATION REPLAY FAILED in Query Store: When Plan Forcing Breaks in SQL Server 2022+

Forcing plans with Query Store can be a powerful tool— until it mysteriously fails. In real production systems, plan forcing sometimes just… doesn’t …

Read More