> You _could_ try adding an identical primary key to the stat_in table as
> you have on the 321st_stat table. However, since we need all of the rows
> from stat_in in the results, I am not sure that it will help speed up the
> join (because it's a left join). Even though I think the index would be
> ignored, it is worth a try to see if it would make a difference with a new
> EXPLAIN..
But it should speed up grouping by PRIMARY KEY in:
insert into 321st_stat select * from stat_in group by
dic,niin,fr_ric,don,suf,dte_txn,sta;
Mikhail.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.