> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]