A Plunge Into TOP

  • Alessandro Mortola

    Say Hey Kid

    Points: 675

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

  • mv_gibson

    SSC Rookie

    Points: 31

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

  • cranberry

    SSC Enthusiast

    Points: 149

    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 2 months, 2 weeks ago by  cranberry.

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

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