ShowPlan Operator of the Week - Merge Join
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Thu, 20 Jan 2011 07:00:00 UT
Indexed on
2011/01/29
15:30 UTC
Read the original article
Hit count: 275
Filed under:
Did you ever wonder how and why your indexes affect the performances of joins? Once you've read Fabiano Amorim's unforgettable explanation, you'll learn to love the MERGE operator, and plan your indexes so as to allow the Query Optimiser to use it.
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
