Post reply

A Plunge Into TOP

  • June 4, 2019 at 12:00 am

    #3644727

    Comments posted to this topic are about the item A Plunge Into TOP

  • June 4, 2019 at 11:19 am

    #3650041

    Thanks for sharing this tip.  The article was laid out nice as well.

  • June 4, 2019 at 2:01 pm

    #3650082

    EDIT: Never mind - you actually mentioned this.

    A lot of this is over my head... but it is my understanding that at a certain point you are comparing queries that are slightly restructured versions of each other in order to prompt the QO to use different kinds of joins.  Can you not do that same thing by explicitly stating which join to use with join "hints"?

    SELECT          [p].[PRODUCTSUBCATEGORYID]
                   ,[d].[SALESORDERID]
                   ,[d].[SALESORDERDETAILID]
                   ,[d].[CARRIERTRACKINGNUMBER]
    FROM            PRODUCTION.[PRODUCT] AS [p]
    INNER [ HASH | LOOP | MERGE ] JOIN SALES.[SALESORDERDETAIL] AS [d]
                 ON [d].[PRODUCTID] = [p].[PRODUCTID]
                AND [d].[MODIFIEDDATE] BETWEEN '20111201' AND '20111228';

    Thanks for the information.

    • This reply was modified 5 years, 6 months ago by  cranberry.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply