Valid 70-764 Dumps shared by PrepAwayExam.com for Helping Passing 70-764 Exam! PrepAwayExam.com now offer the newest 70-764 exam dumps, the PrepAwayExam.com 70-764 exam questions have been updated and answers have been corrected get the newest PrepAwayExam.com 70-764 dumps with Test Engine here:
You maintain a database named DB1 that has a nonpartitioned table. You create an index in the table. Automatic statistic updates are disabled. Uses report that some Microsoft SQL Server Reporting Service (SSRS) queries take long time to run. You determine that the issue is caused by stale statistics for Index1. You need to update the statistics for the index. What should you do?
Correct Answer: D
Explanation/Reference: Explanation: UPDATE STATISTICS updates query optimization statistics on a table or indexed view. The ALL | COLUMNS | INDEX options update all existing statistics, statistics created on one or more columns, or statistics created for indexes. If none of the options are specified, the UPDATE STATISTICS statement updates all statistics on the table or indexed view. Note: 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. References: https://docs.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql?view=sql-server-2017