Missing Column Statistics Error in Trace When DB Has Auto Create Statistics ON

How can this be?  Isn't the purpose of Auto Create Statistics to avoid this situation?
kreilkampAsked:
Who is Participating?
 
RWrigleyConnect With a Mentor Commented:
Can you post a couple of the actual errors?  Auto Create statistics only creates the stastistics for a column if that column is used in a Where clause, so its possible that you could have columns that have no statistics (because they've never been referenced in a where clause).  However, my understanding of the auto-create is that if its turned on, you shouldn't see these errors.
0
 
RWrigleyCommented:
Depends...is Auto Update Statistics also turned on?
0
 
kreilkampAuthor Commented:
Both Auto Create Statistics and Auto Update Statistics have been enabled for about a year, but the trace from the day before yesterday shows a number of Missing Column Statistics errors.
0
 
kreilkampAuthor Commented:
Sorry this took so long . . .

1st Error:

EventClass: Missing Column Statistics
TextData:  NO STATS:([regionheader].[rgh_name])

Previous statement for same ClientProcessID:

EventClass:  SQL:BatchStarting

TextData:

SELECT regionheader.rgh_name, regionheader.rgh_id, regionheader.rgh_type
FROM regionheader
WHERE (((regionheader.rgh_type = 1)))
      UNION  
SELECT 'UNKNOWN','UNK',0  

2nd Error:

EventClass:  Missing Column Statistics
TextData:  NO STATS:([invoiceselection].[ivs_sequence],
[invoiceselection].[ivs_copies],
[invoiceselection].[ivs_showactualtype],
[invoiceselection].[ivs_logocompanyname],
[invoiceselection].[ivs_logocompanyloc],
[invoiceselection].[ivs_logocompanyfontsize],
[invoiceselection].[ivs_logopicturefile],
[invoiceselection].[ivs_remittocompanyname],
[invoiceselection].[ivs_remittocompanyloc],
[invoiceselection].[ivs_terms],
[invoiceselection].[ivs_interestrate],
[invoiceselection].[ivs_imageformat],
[invoiceselection].[ivs_daysdue],
[invoiceselection].[ivs_sequence],
[invoiceselection].[ivs_copies],
[invoiceselection].[ivs_showactualtype],
[invoiceselection].[ivs_logocompanyname],
[invoiceselection].[ivs_logocompanyloc],
[invoiceselection].[ivs_logocompanyfontsize],
[invoiceselection].[ivs_logopicturefile],
[invoiceselection].[ivs_remittocompanyname],
[invoiceselection].[ivs_remittocompanyloc],
[invoiceselection].[ivs_terms],
[invoiceselection].[ivs_interestrate],
[invoiceselection].[ivs_imageformat],
[invoiceselection].[ivs_daysdue])

Previous statement for same ClientProcessID:

EventClass:  SQL:BatchStarting
TextData:
SELECT ivh_revtype1,
 ivs_sequence,
 ivs_copies,
 ivs_showactualtype,
 ivs_invoicedatawindow,
 ivs_logocompanyname,
 ivs_logocompanyloc,
 ivs_logocompanyfontsize,
 ivs_logopicturefile,
 ivs_remittocompanyname,
 ivs_remittocompanyloc,
 ivs_terms,
 ivs_invoicetype,
 ivs_interestrate,
 cmp_id,
 ivs_imageformat,
 ivs_company,
 ivs_daysdue  
from invoiceselection  
left outer join company
on ivs_number = cmp_mbformat  
where ivs_invoicetype = 'M'  
        union  
SELECT ivh_revtype1,
 ivs_sequence,
 ivs_copies,
 ivs_showactualtype,
 ivs_invoicedatawindow,
 ivs_logocompanyname,
 ivs_logocompanyloc,
 ivs_logocompanyfontsize,
 ivs_logopicturefile,
 ivs_remittocompanyname,
 ivs_remittocompanyloc,
 ivs_terms,
 ivs_invoicetype,
 ivs_interestrate,
 cmp_id,
 ivs_imageformat,
 ivs_company,
 ivs_daysdue  
FROM invoiceselection  
left outer join company
on ivs_number = cmp_ivformat  
where ivs_invoicetype = 'I'
0
 
kreilkampAuthor Commented:
Thank you for responding.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.