A Plunge Into TOP

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

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

  • 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 years 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