-
PARALLEL query with ROWNUM
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 ???
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|