Posted inSQL
Microsoft
10 years ago
Truncate table support for memory optimized tables
In the scenario that memory optimized tables are used to store the intermediate result set in batch. Usualy the cusotomers want to use truncate table statement rather than delete ... statement to improve the performance. However that statement is not supported for memory optimized table. It would provide great performance benefit ti the customer
Under Review
ProgrammabilitySuggestionsUnder Review
Company Response
Microsoft
Company Response
Up: 2<=-=Feb 6 2015 12:27PM=-=>Thanks very much for your suggestion.We do not have support for TRUNCATE TABLE at this time. Note however that DELETE operations on memory-optimized tables are much more efficient than DELETE operations for traditional disk-based tables, both in terms of runtime and in terms of amount of log generated.If you need the operation to be truly metadata-only, you can drop and recreate the table.�Jos de Bruijn � SQL Server PM
Vote
0 Comments