sql command truncate table completes in seconds. not finish in 2 minutes , truncation session not blocked other sessions.
most due indexes being updated during truncate operation.
it faster drop indexes, truncate, , re-apply indexes once table empty.
note: in case aren't aware, truncate not logged, there's no going once (which may intentional).
