hi friends,

i am using following parallel query to insert 100 million data from sTable to dTable

insert /*+ PARALLEL(dTable,24) */ into dTable
(col6,col1,col2,col3,col4,col5)
select /*+ PARALLEL(sTable,24) FULL(sTable) */
ROWNUM,
col1,
col2,
col3,
col4,
col5
from sTable;

Here, sTable and dTable both are partition (24) table.
Normally this query takes 40 mins.

Now if i remove ROWNUM from above query such as

insert /*+ PARALLEL(dTable,24) */ into dTable
(col1,col2,col3,col4,col5)
select /*+ PARALLEL(sTable,24) FULL(sTable) */
col1,
col2,
col3,
col4,
col5
from sTable s;

Now it takes 15 mins to insert data, which means insert query with ROWNUM is very slow.

I want to use ROWNUM in my query. Is there any other alternative to do it ???