Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Analytical Functions.. need help ...

Analytical Functions.. need help ...

From: Craig <elliott_craig_at_hotmail.com>
Date: 23 Oct 2002 17:50:37 -0700
Message-ID: <4f71eb53.0210231650.4ef0aeb1@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 Wed Oct 23 2002 - 19:50:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US