Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Table join expertise needed badly
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
![]() |
![]() |