Re: Delete performance

The temp table probably differs from ITEM in that: 1. It does not have all these indexes
2. It was created with "NOLOGGING" option

The fastest way to delete all the rows from a highly populated table is TRUNCATE TABLE <table>. But this is because it saves no undo information. You cannot rollback this operation. If you don't like that option, then I'm not really sure if this would be faster, but you may want to drop all indexes, issue the delete, the recreate indexes.

Tom Best Received on Wed Nov 24 1999 - 05:45:08 CST