database statistics

FLAVIO GERMANO 20 Reputation points
2023-05-24T18:13:21.2866667+00:00

how to update all statistics for a specific database in SQL Server 2019 ?

Windows Hardware Performance
Windows Hardware Performance
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Hardware Performance: Delivering / providing hardware or hardware systems or adjusting / adapting hardware or hardware systems.
1,552 questions
0 comments
Accepted answer
  1. Limitless Technology 43,971 Reputation points
    2023-05-25T12:29:51.5366667+00:00

    Hello there,

    You can update query optimization statistics on a table or indexed view in SQL Server by using SQL Server Management Studio or Transact-SQL. 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.

    https://learn.microsoft.com/en-us/sql/relational-databases/statistics/update-statistics?view=sql-server-ver16

    Hope this resolves your Query !!

    --If the reply is helpful, please Upvote and Accept it as an answer--

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest