title: SQL Server In memory tables using tempdb
body: <p>I'm testing in memory tables on SQL 2014 and the execution plan for a particular query is showing a sort in tempdb.</p>
  
  <p><a href="https://i.stack.imgur.com/HMi2n.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HMi2n.png" alt="enter image description here"></a></p>
  
  <p>The query has a join between two in memory tables (on a field that has a nonclustered index in both tables) and a group by with a few sums and counts - the server has plenty of RAM available.</p>
  
  <p>Why is it the query being sorted in tempdb if the tables are"In Memory"?</p>
  
  <p>I'm also wondering why is SQL Suggesting to create an index if the "create index" statement is not allowed on in memory tables.</p>