Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
djugal
Contributor III
Contributor III

Difference between truncate & clear option in all DBoutput

Hi,
Can any1 explain me what is the difference between between truncate & clear option in all DBoutput.
Both of them seems to function similarly. Even the guide tells nothing much.
Can anyone help ?
Thanks,
Jugal
Labels (2)
2 Replies
janhess
Creator II
Creator II

truncate reclaims the space for the table, clear just deletes the rows.
Anonymous
Not applicable

Adding to above by janhess, truncate will be faster than delete.