Showplan Operator of the Week - Merge Interval
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Fri, 28 Jan 2011 07:00:00 UT
Indexed on
2011/01/29
7:30 UTC
Read the original article
Hit count: 389
Filed under:
When Fabiano agreed to undertake the epic task of describing each showplan operator, none of us quite predicted the interesting ways that the series helps to understand how the query optimizer works. With the Merge Interval, Fabiano comes up with some insights about the way that the Query optimizer handles overlapping ranges efficiently.
Free trial of SQL Backup™
“SQL Backup was able to cut down my backup time
significantly AND achieved a 90% compression at
the same time!” Joe Cheng. Download a free trial now.
“SQL Backup was able to cut down my backup time
significantly AND achieved a 90% compression at
the same time!” Joe Cheng. Download a free trial now.
© SQL Server Central or respective owner