Truncate table

Truncate table instead of DELETE ALL

Use TRUNCATE TABLE command instead of DELETE ALL FROM [table] if you need to to remove all records:

TRUNCATE TABLE EmployeeFacts;

/* instead of */

DELETE ALL FROM EmployeeFacts;

Execution of TRUNCATE command in most cases will take less time than Deltetion especially for large tables.