Join Joey D'Antoni for an in-depth discussion in this video Missing index warnings, part of SQL Server Performance for Developers.
- [Instructor] Let's talk about missing index warnings.…This is something that SQL Server Optimizer…gives us and includes in execution plans…and can be a real benefit to helping you tune queries.…However, there are some limitation to what…SQL Server gives us in terms of missing indexes…and there are some behavior that you should be aware of,…and you should, as always, take any index advice…with a grain of salt, it's definitely…more of an art than a science, and later in the course…you'll see a chapter that's dedicated to indexes…and we'll focus on indexes in detail.…SQL Server will give you missing index warnings…as part of your execution plan…if the optimizer determines that…you should index a certain set of columns…in order to give you better performance for a query.…
It does not, however, correlate that information…with anything else, so a missing…index warning is simply for a given query.…You can get recommendations for…overlapping indexes, which can be problematic.…This is something you want to pay attention to and track…
- Query execution
- How to read an execution plan
- What not to do with SQL Server
- Why cursors are bad
- Why scalar UDFs are expensive
- Datatypes and design
- What is a columnstore index?
- Transaction isolation
Skill Level Intermediate
1. Query Execution
2. What Not to Do with SQL Server
3. Datatypes and Design
4. Temporary Objects
7. Isolation Levels
Next steps2m 15s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.