-
Hello all,
I am seek for help from anyone who experience in create a table base on few joins tables which contains million records and has where conditions.
What are the suggestion on this to fasten the table creation process ?
Here is my current situation :
CREATE TABLE EMP
PARALLEL 4
AS SELECT /*+ CHOOSE */ DEPT.a, STORE.b
FROM dept@DBLINK, store@dblink
WHERE a.DEPTID = b.DEPTID;
Note: dept and store tables consists of million records.
Thanks You.
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
|