Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Location
    Melbourne
    Posts
    6

    Unanswered: Does JOIN order effect efficiency?

    Hi all,

    Does JOIN order effect efficiency?

    If I have three large tables to join together should I join the two that I know will cut the number of rows down a lot first and then join the 3rd table or does it make no difference (if I join the first and 3rd - which I know will be a large result set and then join the 2nd).

    Thanks in advance,

    Chiz.

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    it should make no difference. have a look at the query plan to be sure.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •