怎样写出高性能 的 SQL语句(国外英文资料).docVIP

怎样写出高性能 的 SQL语句 (1) integrate simple, unrelated database access: If you have a few simple database query statements, you can integrate them into a query (even if it doesnt matter) (2) delete duplicate records: The most efficient way to delete duplicate records (because of the use of ROWID) : DELETE FROM EMP E WHERE E.R OWID FROM EMP X WHERE X.E MP_NO = e.mp_no. (3) replace DELETE with TRUNCATE: When delete records in a table, under normal circumstances, the rollback segments (rollback segments) used to store information can be restored. If you do not COMMIT transaction, ORACLE will data recove