Monday, February 06, 2017

SQL - Improve Query Performance

Updates query optimization statistics on a table or indexed view. By default, the query optimizer already updates statistics as necessary to improve the query plan; in some cases you can improve query performance by using UPDATE STATISTICS or the stored procedure sp_updatestats to update statistics more frequently than the default updates.

USE db_reports;
GO
UPDATE STATISTICS tb_applicationusage;
GO

No comments: