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

In article <7f966bc5.0301210517.5d3b54ae_at_posting.google.com>,  david_at_fitzg.com (David FitzGerald) wrote:

I would change the following things:

> start_date := '23-Jan-2003';

[Quoted] [Quoted] start_date := to_date('23012003','ddmmyyyy');

> for ctr in 0..6 LOOP
> insert into FORECAST
> values(this_item.item, item.location, start_date+ctr,'0');
> END LOOP;

insert into FORECAST values(..., start_date,'0');
insert into FORECAST values(..., start_date+1,'0');
insert into FORECAST values(..., start_date+2,'0');
insert into FORECAST values(..., start_date+3,'0');
insert into FORECAST values(..., start_date+4,'0');
insert into FORECAST values(..., start_date+5,'0');
insert into FORECAST values(..., start_date+6,'0');

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

Greetings from Switzerland -- Gruesse aus der Schweiz Happl Received on Tue Jan 21 2003 - 16:38:02 CET