asked on

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?

RWrigley

Depends...is Auto Update Statistics also turned on?

kreilkamp

ASKER

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.

ASKER CERTIFIED SOLUTION

RWrigley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kreilkamp

ASKER

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'

kreilkamp

ASKER

Thank you for responding.