Save for later
Optimizing SQL Server Statistics and Indexes
Index maintenance is a complex topic, and one that's crucial for a well-performing database. In this course, Optimizing SQL Server Statistics and Indexes, you will learn foundational knowledge on how to keep your database and indexes well-maintained. First, you will explore missing and unused indexes, looking at how the indexes used by the system change over time. Next, you will discover why indexes, rowstore, and columnstore need maintenance and how to best perform that maintenance. Finally, you will learn how to perform statistics maintenance, allowing you to ensure that the Query Optimizer gets the information it needs to generate good execution plans. When you are finished with this course, you will have the skills and knowledge of index maintenance needed to keep your database running smoothly.
Get a Reminder
| Rating | Not enough ratings |
|---|---|
| Length | 1.8 hours |
| Starts | On Demand (Start anytime) |
| Cost | $35/month (Access to entire library- free trial available) |
| From | Pluralsight |
| Instructor | Gail Shaw |
| Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
| Language | English |
| Subjects | IT & Networking |
| Tags | Data Professional |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Maintenance/Housekeeping $26k
Guest Maintenance $31k
Warehouse Maintenance $67k
Maintenance Person $73k
Maintenance Technician 1 2 3 $74k
Maintenance Specialist 3 $76k
Maintenance Operator 1 $78k
Project Maintenance $80k
Index Derivatives Trader $96k
Pipeline maintenance $99k
Leader, Maintenance $104k
Mercer Management Consulting & CSC Index Strategy Consulting Consultant $105k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | Not enough ratings |
|---|---|
| Length | 1.8 hours |
| Starts | On Demand (Start anytime) |
| Cost | $35/month (Access to entire library- free trial available) |
| From | Pluralsight |
| Instructor | Gail Shaw |
| Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
| Language | English |
| Subjects | IT & Networking |
| Tags | Data Professional |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
