Monday, October 13, 2014

0 SQL2014: In Memory OLTP (3) Statistic

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.

image

DBCC SHOW_STATISTICS is empty.

DBCC SHOW_STATISTICS('dbo.customer_mem',[PK__customer__52F8CC95C735FE7E])

image

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

image

image

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates