Re: help~~PARALLEL DML Question

In article <85nba2$4cb$1_at_news.inet.tele.dk>,   "Ivan Bajon" <iba_at_no_spam_at_post1.tele.dk> wrote:
> alter session enable parallel dml;
> insert /*+PARALLEL(dest_table,10)+*/ into dest_table select
> /*+PARALLEL(source_table,10)*/ * from source_table;
>
> The above is using Parallel Query - not Parallel Server - but it
should be
> way faster than normal "insert as select".
>
> hth,
> Ivan Bajon, ocp

Ivan

   Besides,when should I used parallel insert ??    parallel insert (insert append) will increase the total extents    will it caused performance down in the future for query ??

Agi Chen

>
> agichen <agiNOagSPAM_at_feib.com.tw.invalid> wrote in message
> news:15f5621a.544df703_at_usw-ex0102-013.remarq.com...
> > Hello,there
> > I have a partition table (with 10 partitions) on ver 8.0.5 with
> > parallel server option.
> > Now I want to insert 5M records from another table,how to write
> > hint in my parallel insert to speed up my task ??
> >
> > ps.we have 2 node(RS/6000 2CPUs per node)
> >
> > Rgds,
> > Agi Chen
> >
> >
> >
> > * Sent from RemarQ http://www.remarq.com The Internet's Discussion
Network
> *
> > The fastest and easiest way to search and participate in Usenet -
Free!
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 14 2000 - 18:47:42 CST