Home » SQL & PL/SQL » SQL & PL/SQL » Performance Essue (Oracle 9i,XP)
Performance Essue [message #336582] Mon, 28 July 2008 05:02 Go to next message
orasuman7
Messages: 4
Registered: July 2008
Location: BANGALORE
Junior Member
HI Team
I want to know one performance doudt
that is
i have a 10 table with constraints
i want to join all the table
we can do in to way one is join all table at a time
and othere one is one output to othere table what is best way to perform the join

Thanks for Advance
Ora
Re: Performance Essue [message #336588 is a reply to message #336582] Mon, 28 July 2008 05:29 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can only join 2 tables and this can be repeated for each table.

Regards
Michel
Previous Topic: dbms_sql
Next Topic: partition
Goto Forum:
  


Current Time: Sat Dec 03 22:25:21 CST 2016

Total time taken to generate the page: 0.10789 seconds