Optimizing Statisitics & Indexes
SQL Server 2016
| Intermediate
- 11 Videos | 1h 2m 47s
- Includes Assessment
- Earns a Badge
Optimizing statistics helps ensure the most efficient means of executing statements in SQL Server 2016. Discover how to create, modify, and troubleshoot statistics and indexes in SQL Server 2016.
WHAT YOU WILL LEARN
-
create statistics and determine accuracy of resultsmodify existing statisticsview statistic propertiesupdate query optimization statisticsdescribe available maintenance tasks to performperform database tuning using the database engine tuning advisor
-
demonstrate how to create a maintenance planperform index defragmentationreview current index usage and identify missing indexesidentify and consolidate overlapping indexesuse statistics objects and index optimization methods
IN THIS COURSE
-
1.Creating Statistics7m 13sUP NEXT
-
2.Modifying Statistics3m 38s
-
3.Viewing Statistics Properties5m 48s
-
4.Updating Statistics3m 33s
-
5.Maintenance Tasks3m 25s
-
6.Database Engine Tuning Advisor7m 22s
-
7.Creating a Maintenance Plan6m 43s
-
8.Defragmenting Indexes9m 31s
-
9.Reviewing Dynamic Management Objects4m 34s
-
10.Overlapping Indexes4m 46s
-
11.Exercise: Work with Statistics and Optimize Indexes6m 13s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.