New answers tagged memory-optimized-tables
2
votes
Accepted
Is there any disadvantage to moving a small and frequently read read-only table to in-memory OLTP?
Doesn't something about the data structure make in-memory OLTP tables smaller and therefore faster to read?
Rows are not necessarily smaller, but defined as C-style structs, and accessed by generated ...
Top 50 recent answers are included
Related Tags
memory-optimized-tables × 107sql-server × 82
sql-server-2016 × 23
sql-server-2014 × 15
sql-server-2017 × 12
sql-server-2019 × 9
in-memory-database × 9
mysql × 6
performance × 6
memory × 6
oracle × 4
t-sql × 4
temporary-tables × 4
optimization × 3
azure-sql-database × 3
transaction-log × 3
database-design × 2
query-performance × 2
index × 2
mariadb × 2
stored-procedures × 2
execution-plan × 2
configuration × 2
upgrade × 2
recovery × 2