This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Load one Oracle table with contents from three different tables Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Load one Oracle table with contents from three different tables" Watch "Load one Oracle table with contents from three different tables" New topic
Author

Load one Oracle table with contents from three different tables

Atul Mishra
Ranch Hand

Joined: Jun 08, 2006
Posts: 140
Hi all,

We have to create a new Oracle table using subset of data from 3 existing Oracle tables.
The data is huge, around 90M.

We have tried procedures which use Oracle JOINs across the three tables. The performace is not as quick.
Could anyone please suggest any tools/ faster mechanisms through which we can achive this ?

Thanks
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
I doubt you will find anything quicker than running a join in Oracle.
The only other thing you can check is if the fields you are joining on
are indexed in the tables.
 
jQuery in Action, 2nd edition
 
subject: Load one Oracle table with contents from three different tables
 
Similar Threads
EJB Using the Oracle Database
calculation
how to insert
How to implement this? Map database tables to a java object
Database Design issue