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. SQL Backup 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 Server Central or respective owner