Re: Analytical Functions.. need help ...

From: zudu <zudu_at_yahoo.com>
Date: Sat, 26 Oct 2002 20:29:34 +0200
Message-ID: <apemop$vbe$02$2@news.t-online.com>

where is your explain plan ??

parallel to serial is ok , it is done parallel and the next step is serial

the scan, window sort and hash join can be done in parallel

the time saving is fantastic, dependent on the number of cpu you have

64 seems to much, how many cpu you have ?

why do people expect help and don't give any information ???

"Craig" <elliott_craig_at_hotmail.com> schrieb im Newsbeitrag news:4f71eb53.0210231650.4ef0aeb1_at_posting.google.com...
> Greetings,
>
> I am using the LEAD..OVER.. function.
> Basically I am using LEAD(status) OVER (ORDER BY ORDERNUM,
> DATETIMEFIELD, SEQNUM DESC) AS Nextstatus.
> I am getting the status of the order following the current order.
>
> When I do an explain plan the parallel is "PARALLEL TO SERIAL".
> is there any way to get this to "PARALLEL TO PARALLEL"?
> Is it possible to speed this up?
>
> The table was created with PARALLEL 64.
> Now I do not expect to get a fantastic time saving, just would like to
> cut another 20 - 30 mins of the 2.5 hours it takes to run to process
> the 115,000,000 records.
>
> Thanks,
> Craig.
Received on Sat Oct 26 2002 - 13:29:34 CDT