Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Table join expertise needed badly

Table join expertise needed badly

From: Brian L <brilarso_at_gmail.com>
Date: 14 Apr 2006 10:10:38 -0700
Message-ID: <1145034638.494116.297410@v46g2000cwv.googlegroups.com>


Hi there,

I have about 20 tables that I need to join together and I need help on a strategy. I can ultimately tie all the table back to one base table.

My other option is to to join 10 tables together and then the other 10 together and have those hook together through 1 base table in each group.

What is the bast way for performace? My instinct tells me I should hook everything to the one table but I have no proof to support that.

Any suggestions on whether to chain tables together or to use 1 anchor??

Thanks,

-Brian Received on Fri Apr 14 2006 - 12:10:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US