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 Thu Oct 24 2002 - 02:50:37 CEST