Re: Optimising PL/SQL Script. Takes 2 days to run.

> start_date := to_date('23012003','ddmmyyyy');

What difference does this make? Is it purely good form to do it like this or is there a speed boost?

> Are indexes created on table FORECAST? if yes, you
> should drop them before inserting so many rows.

Since I posted last, I did what you said and changed the date, removed the loop and used 7 inserts and I also disabled all constraints and indexes on the table. As a result, things seem to run about 40% faster. Wow! Hopefully since the data is being inserted in a good order the rebuilding of the index will be fast.

Thanks for your help!

On a sidenote -- if it errors during the insert, is it possible to tell Oracle to re-run picking up where it left off?

David. Received on Wed Jan 22 2003 - 07:21:32 CST