Create Table – Disk vs In-Memory Optimized

Moved from:


I had an interesting e-mail discussion related to the performance of create table.  The test being executed was a tight loop of create table statements.  The assumption put forth was in-memory optimized table creation was slower and they expected it to be faster.  We are not talking about the performance of inserts, updates, deletes and selects but instead looking at the time it takes to perform create table.

The answer is that the creation of in-memory optimized tables might be slower than disk based table creation.   Let’s take a high level look at the create table