Replacing the data in a large table

If you are replacing all the data in a large table, use truncate table, which performs reduced logging, instead of delete. Only page deallocations are logged.

  1. Truncate the table.

  2. Drop all indexes on the table.

  3. Load the data.

  4. Recreate the indexes.

See the Reference Manual: Commands.