Optimizing Statisitics & Indexes
SQL Server 2016
| Intermediate
- 11 Videos | 1h 7m 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 results
modify existing statistics
view statistic properties
update query optimization statistics
describe available maintenance tasks to perform
perform database tuning using the database engine tuning advisor -
demonstrate how to create a maintenance plan
perform index defragmentation
review current index usage and identify missing indexes
identify and consolidate overlapping indexes
use 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.
