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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2007-10-15 04:22 AM

Delete or truncate table

Hi !
When you choose to clear the table before inserting datas you do a "delete from ...." Why ? You could do a "truncate ...". It will be quicker !
Thanks a lot.
Kim
Labels (2)
Labels
198 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2007-10-15 06:43 AM
Author

It was like that in version 2.1.2 (1608]), but changed in version 2.1.4 1813]... 0683p000009MPcz.png
So I use now a component tOracleRow to truncate table.
I hope this help !
198 Views
0 Likes
Anonymous
Not applicable
‎2007-10-15 07:05 AM
Author

Hi all
It's a problem in TOS. I have reported a new 2275
Thanks for your support!
Best regards
shong
198 Views
0 Likes