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:
Post a Comment