HI Folks,
i have 1 TB size table i.e. tbl_vpn which is not partitioned. i'm trying to create the table tbl_sub like below, it's taking more than 24 hours to create it
CREATE TABLE tbl_sub
NOLOGGING AS
SELECT /*+ PARALLEL(a,6,6) PARALLEL(b,6,6)*/
A.INTER, A.ROW_ADDED_DT,
TO_CLOB(A.NOTES) NOTES
FROM tbl_vpn a,
tbl_act b
WHERE a.id = b.id;
now my query is, if i create the tbl_sub table as partitioned then i try to inserting data into table with the same select statement will it improve the performance of data insertion?
Many thanks in advance,
Harikanth.