• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Load one Oracle table with contents from three different tables

 
Atul Mishra
Ranch Hand
Posts: 140
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic