Skip to main content
Database Administrators

Return to Question

deleted 18 characters in body; edited tags
Source Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 424
  • 663

I have a situation that I cantcan't understand. My SQL SERVERServer execution plan tells me that I have missing statistics on the table, but the statistics isare already created. Please see the screens. :

Warning

But if we look onat the table, we will see that there is a statstatistic that has been created automaticly.automatically:

enter image description here

Can somebody help to understand how it can be.?

Auto_Update and Auto_Create statistics is turned on on the current DB.

I am using SQL SERVERServer 2014.

I have a situation that I cant understand. My SQL SERVER execution plan tells me that I have missing statistics on the table, but the statistics is already created. Please see the screens. Warning

But if we look on the table, we will see that there is a stat that has been created automaticly.

enter image description here

Can somebody help to understand how it can be.

Auto_Update and Auto_Create statistics is turned on on the current DB.

I am using SQL SERVER 2014.

I have a situation that I can't understand. My SQL Server execution plan tells me that I have missing statistics on the table, but the statistics are already created:

Warning

But if we look at the table, we will see that there is a statistic that has been created automatically:

enter image description here

Can somebody help to understand how it can be?

Auto_Update and Auto_Create statistics is turned on on the current DB.

I am using SQL Server 2014.

Tweeted twitter.com/#!/StackDBAs/status/603430758250913792
added 31 characters in body
Source Link
Artashes Khachatryan
Artashes Khachatryan
  • 1.5k
  • 1
  • 12
  • 23

I have a situation that I cant understand. My SQL SERVER execution plan tells me that I have missing statistics on the table, but the statistics is already created. Please see the screens. Warning

But if we look on the table, we will see that there is a stat that has been created automaticly.

enter image description here

Can somebody help to understand how it can be.

Auto_Update and Auto_Create statistics is turned on on the current DB.

I am using SQL SERVER 2014.

I have a situation that I cant understand. My SQL SERVER execution plan tells me that I have missing statistics on the table, but the statistics is already created. Please see the screens. Warning

But if we look on the table, we will see that there is a stat that has been created automaticly.

enter image description here

Can somebody help to understand how it can be.

Auto_Update and Auto_Create statistics is turned on on the current DB.

I have a situation that I cant understand. My SQL SERVER execution plan tells me that I have missing statistics on the table, but the statistics is already created. Please see the screens. Warning

But if we look on the table, we will see that there is a stat that has been created automaticly.

enter image description here

Can somebody help to understand how it can be.

Auto_Update and Auto_Create statistics is turned on on the current DB.

I am using SQL SERVER 2014.

Source Link
Artashes Khachatryan
Artashes Khachatryan
  • 1.5k
  • 1
  • 12
  • 23

Warning for missing statistics in execution plan

I have a situation that I cant understand. My SQL SERVER execution plan tells me that I have missing statistics on the table, but the statistics is already created. Please see the screens. Warning

But if we look on the table, we will see that there is a stat that has been created automaticly.

enter image description here

Can somebody help to understand how it can be.

Auto_Update and Auto_Create statistics is turned on on the current DB.