-- Update all statistic of a Database
EXEC sp_updatestats;
-- Update statistic of a Table
UPDATE STATISTICS Table_Name
-- Update statistic of an Index
UPDATE STATISTICS Table_Name Index_Name
asp.net,c#.net, MVC, WPF, WCF, JavaScript, JQuery, SQL Server, Interview Q&A
-- Update all statistic of a Database
EXEC sp_updatestats;
-- Update statistic of a Table
UPDATE STATISTICS Table_Name
-- Update statistic of an Index
UPDATE STATISTICS Table_Name Index_Name