oracle优化稿子
oracle优化文章
http://caihorse.iteye.com/blog/538432
删除重复记录的SQL
SELECT * FROM aaa E WHERE E.ROWID > (SELECT MIN(X.ROWID) FROM aaa X WHERE X.AA = E.AA);
DELETE FROM aaa E WHERE E.ROWID > (SELECT MIN(X.ROWID) FROM aaa X WHERE X.AA = E.AA);