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
Messages: 4
Registered: July 2008
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
Re: Performance Essue [message #336588 is a reply to message #336582] Mon, 28 July 2008 05:29 Go to previous message
Michel Cadot
Messages: 63923
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.

Previous Topic: dbms_sql
Next Topic: partition
Goto Forum:

Current Time: Tue Oct 25 22:03:16 CDT 2016

Total time taken to generate the page: 0.06061 seconds