Load one Oracle table with contents from three different tables

[Atul Mishra]

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]

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.