Post reply

Nested Join vs Merge/hash Join

  • April 18, 2008 at 3:28 am

    #70343

    Dear All,

    Which one is the best method to use in our normal queries ? Also if anyone share their real experience over these types of join it would be very helpful.

    As of my knowledge,By default Nested iteration will be taken by the queries.

    karthik

  • April 18, 2008 at 4:35 am

    #804210

    Whichever one the optimiser chooses. Don't use join hints.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 18, 2008 at 5:17 am

    #804238

    [font="Verdana"]Query Optimizer choose best suitable execution plan for a query on its own. So generally it is recommended not to use Join hints in a query.

    Mahesh[/font]

    MH-09-AM-8694

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

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