Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Analytical Functions.. need help ...
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 Wed Oct 23 2002 - 19:50:37 CDT