Wednesday, 21 April 2010

Index Issue : Missing Statistics

Hovering over the estimated execution plan for a query, the yellow explanation mark alerted me to...

Warnings : Columns with no statistics  format : dbname.schemaname.tablename.columnname

2 steps to perform here -

1) DBCC SHOW_STATISTICS('processing.ipcitylookup','ixCityLookup')
2) UPDATE STATISTICS processing.ipcitylookup

No comments: