https://community.qlik.com/t5/Talend-Studio/Difference-between-truncate-clear-option-in-all-DBoutput/m-p/2296472#M69129 truncate reclaims the space for the table, clear just deletes the rows. Wed, 19 Oct 2011 12:47:57 GMT janhess 2011-10-19T12:47:57Z https://community.qlik.com/t5/Talend-Studio/Difference-between-truncate-clear-option-in-all-DBoutput/m-p/2296471#M69128 Hi,<BR />Can any1 explain me what is the difference between between truncate &amp; clear option in all DBoutput.<BR />Both of them seems to function similarly. Even the guide tells nothing much.<BR />Can anyone help ?<BR />Thanks,<BR />Jugal Sat, 16 Nov 2024 12:36:52 GMT https://community.qlik.com/t5/Talend-Studio/Difference-between-truncate-clear-option-in-all-DBoutput/m-p/2296471#M69128 djugal 2024-11-16T12:36:52Z https://community.qlik.com/t5/Talend-Studio/Difference-between-truncate-clear-option-in-all-DBoutput/m-p/2296472#M69129 truncate reclaims the space for the table, clear just deletes the rows. Wed, 19 Oct 2011 12:47:57 GMT https://community.qlik.com/t5/Talend-Studio/Difference-between-truncate-clear-option-in-all-DBoutput/m-p/2296472#M69129 janhess 2011-10-19T12:47:57Z https://community.qlik.com/t5/Talend-Studio/Difference-between-truncate-clear-option-in-all-DBoutput/m-p/2296473#M69130 Adding to above by janhess, truncate will be faster than delete. Wed, 19 Oct 2011 15:25:40 GMT https://community.qlik.com/t5/Talend-Studio/Difference-between-truncate-clear-option-in-all-DBoutput/m-p/2296473#M69130 Anonymous 2011-10-19T15:25:40Z