Does the "Delete Data and Append" option in an output tool execute a "TRUNCATE" command or "DELETE...FROM" against the SQL server table? The reason I ask is because the TRUNCATE command is much more efficient than DELETE.
This article indicates a Truncate: Solved: Options in Output tool - Alteryx Community
Plus this one: Write Data In-DB - Delete Data & Append - Single T... - Alteryx Community
