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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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.