By default , statistic on the memory optimized table is not been auto created. Therefor, if we take a look at query plan, the actual number of rows and estimated number of rows have huge difference.
DBCC SHOW_STATISTICS is empty.
DBCC SHOW_STATISTICS('dbo.customer_mem',[PK__customer__52F8CC95C735FE7E])
We need to run UPDATE STATISTICS to generate the stats It needs to run as FULLSCAN and NORECOMPUTE.
UPDATE STATISTICS customer_mem WITH FULLSCAN,NORECOMPUTE
0 comments:
Post a Comment