File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Load one Oracle table with contents from three different tables
Joined: Jun 08, 2006
Jan 20, 2010 14:07:47
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 ?
Joined: Jan 24, 2006
Jan 27, 2010 10:40:20
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.
It is sorta covered in the
JavaRanch Style Guide
subject: Load one Oracle table with contents from three different tables
Database Design issue
how to insert
EJB Using the Oracle Database
How to implement this? Map database tables to a java object
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015