1. Welcome Guest! In order to create a new topic or reply to an existing one, you must register first. It is easy and free. Click here to sign up now!.
    Dismiss Notice

SQL Server: Avoiding a Sort with Merge Join Concatenation

Discussion in 'Microsoft News' started by Itzik Ben-Gan, Dec 18, 2017.

  1. Itzik Ben-Gan

    Itzik Ben-Gan Guest

    There are cases when SQL Server doesn’t normally realize it can rely on index order, but you can make the platform realize it with some extra manipulation and creativity. This article is the first in a two-part series in which I describe such tasks and solutions. This month I’ll talk about avoiding a sort with the Merge Join (Concatenation) operator. Next month I’ll describe avoiding a sort when needing the data in descending order.

    Continue reading...
     
    Itzik Ben-Gan, Dec 18, 2017
    #1

Share This Page