| SQL with and without "Parallel" option [message #227109] |
Tue, 27 March 2007 06:16  |
mymot
Messages: 225
Registered: July 2005
|
Senior Member |
|
|
Hello,
I have got a very simple sql to insert record into the table
insert into tab1 ( columns......)
select /* + parallel(tab) */ * from
tab where tab.indicator = 'P'
Above query was taking min 4/5 hours to insert 1.4 millions record, i dont understand if it a single table , running on unix platform, Oracle 9i
SQL was tested with and without Parallel option but there was no change in query behavior
Any suggestions to make this query faster,
why query does behave with or without "Parallel"
Thanks
|
|
|
|
|
|
|
|
|
|
| Re: SQL with and without "Parallel" option [message #227132 is a reply to message #227123] |
Tue, 27 March 2007 07:18  |
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
|
Senior Member |
|
|
Have you tried this option
disable the index.
insert /*+ append */ from <table_a> select ... from table_b;
commit;
rebuild the index.
I am not able to find any way of improvement in the performance by having a parallel hint in your select.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
