Home » RDBMS Server » Server Administration » Maximum number of joins
Maximum number of joins [message #371458] Mon, 23 October 2000 11:07 Go to next message
Brent Stayer
Messages: 6
Registered: October 2000
Junior Member
What is the maximum number of joins that I can have in a query?

Report message to a moderator

Re: Maximum number of joins [message #371459 is a reply to message #371458] Mon, 23 October 2000 14:45 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
I've never encountered a physical limit, only a practical limit. Rapidly increasing response times usually keeps the number of joins down.
You can have a max of 1 outer join per query though. Sub queries or dynamic views can overcome this though.

Report message to a moderator

Previous Topic: Re: Database not starting up on NT
Next Topic: creating a database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 15:54:57 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.