I understand that there are many variables in this and am not looking for an exact number of min:sec :) I've read many resources that state that a
TRUNCATE uses far less resources than a
DELETE and hence will perform faster. But there are no order of magnitudes mentioned. As a
TRUNCATE is a DDL (Data Definition Language) operation and not a DML (Data Manipulation Language) operation and only the system tables are part of the transaction, I'm presuming that it should not take very long.
Anyone with experience on doing this with a table anywhere near this size that can lend some insight? We talking up to a minute, up to an hour, days, weeks?