Re: Is there any limit to Left Join ?
From: Mike Hodgson (mike.hodgson_at_mallesons.nospam.com)
Date: 02/22/05
- Next message: wc chan: "Fatal exception caught and SQL abort"
- Previous message: Peter: "Is there any limit to Left Join ?"
- In reply to: Peter: "Is there any limit to Left Join ?"
- Next in thread: Mark Rae: "Re: Is there any limit to Left Join ?"
- Reply: Mark Rae: "Re: Is there any limit to Left Join ?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 22 Feb 2005 15:36:21 +1100
Nah - no practical limit (the maximum tables per SELECT statement in SQL
Server 8.0 is 256). If you look at the grammar for the FROM clause in
BOL you'll see it's a recursive grammar.
If you were to join a couple hundred tables in your FROM clause you'd
probably hit some limits when you started running out of memory in the
procedure cache for your query plan and the CPU ground to a halt trying
to process the mother of all queries but if you stay under 200 joins in
a single query you should be OK. ;-)
Happy joining!
-- *mike hodgson* |/ database administrator/ | mallesons stephen jaques *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907 *E* mailto:mike.hodgson@mallesons.nospam.com |* W* http://www.mallesons.com Peter wrote: >I am going to create a query with more than 1 LEFT JOIN. >I would like to know is there any limit (Like only 1 can >be used) in SQL Server 2000 ? > >Thanks > >
- Next message: wc chan: "Fatal exception caught and SQL abort"
- Previous message: Peter: "Is there any limit to Left Join ?"
- In reply to: Peter: "Is there any limit to Left Join ?"
- Next in thread: Mark Rae: "Re: Is there any limit to Left Join ?"
- Reply: Mark Rae: "Re: Is there any limit to Left Join ?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
