From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Implement statistics for large tables - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Implement statistics for large tables
- [Narrator] Updating statistics can take a little time. As your data tables get larger, the time it takes to compute the statistics gets longer. It could take from seconds to minutes to hours. If you have automatically updating statistics turned on, and they're set to perform synchronously, this can lead to Query's timing out. To prevent this, consider updating the statistics on your tables manually. And at a scheduled time, during off peak hours. Or when the process will have less impact on your users. Another option, is to update the statistics based on a sampling of your data, instead of the full data set. This reduces the number of records that need to be evaluated. And for larger data tables, a random sampling of values can yield just as accurate of a result. Let's take a look inside the WideWorldImporters database. And I want to update the statistics for an index on the application dot people table, and the index is named IX Application People FullName. When you include the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.