CODEWITHSUNDEEP
sqlouter-join
astudentofmaths
astudentofmaths

Reputation: 1163

How many "outer joins" can a table have?

Everything is in the title: if I do a select query across several tables, how many outer joins can I use? As many tables there are?

Upvotes: 0

Views: 117

Answers (2)

Neo
Neo

Reputation: 3399

Typically the DBMS limit will be higher than you should ever need. There is a common sense limit in terms of how many joins to use for effective querying. This needs to be part of your over all design consideration ( your app, your db schema \ indexing, etc. )

Upvotes: 1

Jens
Jens

Reputation: 3299

See "Tables per SELECT statement": Maximum Capacity Specifications for SQL Server

  • For SQL Server 2008 & up the maximum is only limited by available resources.
  • For SQL Server 2005 there was a 256 table limit.

Upvotes: 3

Related Questions