Post reply

Maximum or recommended number of joins in statement

  • February 10, 2004 at 3:31 pm

    #161615

    Just wondering if there is a maximum number of joins recommended in a select statement for sql server 2000 ?

  • February 10, 2004 at 3:46 pm

    #493510

    I have heard various numbers tossed around in the passed. It boils down to performance, for best performance denormalize so you can do fewer joins. However with newer and faster systems it is almost limitless what you can do just make sure you don't join in tables that will not be used in the output. I am not sure of a maximum number of joins you can thou but if you use process items such as ORDER BY which sort in a temp table under the hood you will run into the 8k limit if you join data that would cause to be wider for the output than that.

  • February 10, 2004 at 5:24 pm

    #493533

    You will have to test it for yourself!

    I have up to 10 joins in some stored procedures with no performance problems or concurrency issues! However, I would not recommend 10 joins to any one rather it's best to test it yourself in a development environment!

    Kindest Regards,

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

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