title: Recompilation issue with in-memory tables
body: <p>In our high-loaded OLTP processing we're using permanent in-memory tables like temporary tables (similar to <a href="https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/faster-temp-table-and-table-variable-by-using-memory-optimization?view=sql-server-2017" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/faster-temp-table-and-table-variable-by-using-memory-optimization?view=sql-server-2017</a>, case C). But, under a low load we found very big number of recompilations in stored procedures caused by the reason '2 - Statistics changed'. Number of rows in these tables varies from 0 to 50-100 each execution. There is no way to disable auto update statistics on in-memory tables. Also, an option 'KEEPFIXED PLAN' cannot be applied in subqueries like this:</p>
  
  <pre><code>if exists(
      select 1 from dbo.mytable option (KEEPFIXED PLAN)
  )
  begin
      select 1
  end
  </code></pre>
  
  <p>Any ideas, how can we avoid excessive recompilations?</p>