Join Joey D'Antoni for an in-depth discussion in this video Filtered indexes, part of SQL Server Performance for Developers.
- [Instructor] Let's talk about filtered indexes.…This is a feature that was introduced…in SQL Server 2008.…It's something I don't see commonly.…It doesn't always have a ton of use cases,…but there are some specific use cases where you want…to be able to take advantage of this feature.…You may ask, "What do we mean by creating a filtered index…versus just a normal index?"…A filtered index is simply a non-clustered index…with a where clause, just like…you would put in a select statement.…When doing this where clause, you're excluding…a group of records from your index.…This means a couple of things.…
It gives you a smaller overall index on disk,…it gives you increased selectivity, so the queries…that can use that filtered index are going to return…faster and perform less logical reads…because the index is going to have more specific information.…Where do you really want to use filtered indexes?…When you have a high degree of data skew,…so if you have a large number of distinct values…and maybe a lot of records that all have…
- 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.