We are running Oracle 8i on Sun Solaris 2.8.
My question is:
1. Is the insert phase of insert into ... select
parallelized in sync with select?
2. Does the insert phase use direct path mechanism?
I know the answers are yes for both of the questions if
it is create table ... as select (pCATS), but not sure
about insert into... select