Lotsa joins 
Author Message
 Lotsa joins

Couldn't find it in the manuals...is there a limit to the number of
tables that can be joined in a single query?
Is there a better way of joining a central table through several bridge
tables to their lookup tables?

_________________________
Herb Blacker
Database Administrator
ReCare, Inc.
(512) 791-4340

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Sun, 25 Jul 2004 13:51:40 GMT
 Lotsa joins

Quote:

> Couldn't find it in the manuals...is there a limit to the number of
> tables that can be joined in a single query?
> Is there a better way of joining a central table through several bridge
> tables to their lookup tables?

No limit, in fact, we have GEQO which automatically reduces problems
with expoential growth of optimizer choices.

--
  Bruce Momjian                        |  http://candle.pha.pa.us

  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Sun, 25 Jul 2004 20:11:25 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Linux SE lotsa users

2. SQL query with lotsa params...

3. Right Join / Hash Joins / Nested Joins

4. Syntactic difference JOIN ON JOIN ON and JOIN JOIN ON ON?

5. LEFT OUTER JOIN faster than INNER JOIN?

6. Full outer join in SQLServer 2000 giving me results of inner join

7. Theoretical Question on LEFT JOIN vs. INNER JOIN

8. Converting ANSI Joins to "readable" joins

9. Problem with Outer join and Inner joins

10. Help on converting old style JOIN to ANSI JOIN

11. old join and new join

12. Left join vs right join - Performance


 
Powered by phpBB® Forum Software