Script categories

Monday, 31 October 2011

Useful way to improve peformance of bulk DELETE

delete from table1
where
rowid in ( select rowid
           from table1 group by rowid, col_id
           minus
           select max(rowid)
           from table1 group by col_id);
 

2 comments: