Lotsa joins
Started by Herb Blackerabout 24 years ago2 messagesgeneral
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
herbblacker@isgenesis.com
Re: Lotsa joins
Herb Blacker wrote:
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
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026