Skip to main content
added 23 characters in body; edited title
Source Link
marc_s
  • 9k
  • 6
  • 45
  • 52

Statics Statistics and Execution plan in sql serverSQL Server

I have table Reg_StatsReg_Stats table without any index, statics isindexes. Statistics are not updating automatically but iI have enabled the autoupdate statics alsostatistics (is_auto_create_stats_onis_auto_create_stats_on,is_auto_update_stats_on is_auto_update_stats_on are both are oneon) And my.

My second promblemproblem: once iI updated statics manualystatistics manually, it is showing correctly but in execution plan it is not showing properly.   

enter image description here

Statics and Execution plan in sql server

I have table Reg_Stats without any index, statics is not updating automatically but i have enabled the autoupdate statics also (is_auto_create_stats_on,is_auto_update_stats_on both are one) And my second promblem once i updated statics manualy it showing correctly but in execution plan it is not showing properly.  enter image description here

Statistics and Execution plan in SQL Server

I have table Reg_Stats table without any indexes. Statistics are not updating automatically but I have enabled the autoupdate statistics (is_auto_create_stats_on, is_auto_update_stats_on are both are on).

My second problem: once I updated statistics manually, it is showing correctly but in execution plan it is not showing properly. 

enter image description here

Source Link
Neminath
  • 49
  • 3
  • 10

Statics and Execution plan in sql server

I have table Reg_Stats without any index, statics is not updating automatically but i have enabled the autoupdate statics also (is_auto_create_stats_on,is_auto_update_stats_on both are one) And my second promblem once i updated statics manualy it showing correctly but in execution plan it is not showing properly. enter image description here