Consider Using the DELETE FIRST Clause

If you want to delete a large number of rows and TRUNCATE TABLE is not appropriate, consider using the DELETE FIRST NumRows clause to delete rows from a table in batches.

The DELETE FIRST NumRows syntax allows you to change “DELETE FROM TableName WHERE . . ." into a sequence of “DELETE FIRST 10000 FROM TableName WHERE . . ." operations.

By splitting a large DELETE operation into a batch of smaller operations, the rows will be deleted much faster, and the overall concurrency of the system and replication will not be affected.

For more information about the DELETE FIRST clause, see DELETE in the Oracle TimesTen In-Memory Database SQL Reference.