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