Announcements
No record found.
Both InMemory and TempDB table types are temporary tables when should each type be used ?
*This post is locked for comments
On Google you find lots of information, see two link.
msdn.microsoft.com/.../bb314749.aspx
msdn.microsoft.com/.../gg845661.aspx
The key difference is that InMemory is in the AOS memory scope and TempDB is on the SQL Server temporary database. What you should consider is when you need to have a query where you want to join tables it is best to have them on the SQL Server. So if your table must be temporary and you need to use it in joined queries, put it on TempDB. SQL Server will be able to produce the result quicker than having to let the AOS join a result from the SQL Server with some in memory table.
Hi All,
The scope of InMemory and TempDB table types are same, right?
The record exist as long as you have the variable for the table type. If declare two different variables or same variable but two difference session (for eg: open two same form / two login session), it will be not available to you.
Thank you.
Couple of more differences and limitations are highlighted here community.dynamics.com/.../temporary-tables-inmemory-vs-tempdb
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader
