How to Update Statistics on Table and Index - SQL server
UPDATE STATISTICS dbo.TableName
UPDATE STATISTICS dbo.TableName indexNameOnTableName
UPDATE STATISTICS dbo.TableName indexNameOnTableName with fullscan
UPDATE STATISTICS dbo.TableName
UPDATE STATISTICS dbo.TableName indexNameOnTableName
UPDATE STATISTICS dbo.TableName indexNameOnTableName with fullscan