Filtered Index Basics
![](https://i0.wp.com/sqlespresso.com/wp-content/uploads/2019/05/catch_bigger_things_800_wht_14854.jpg?fit=350%2C350&ssl=1)
In this post, we continue with another beginner’s blog of database features that may be unknown to many. Let’s take a look at filtered indexes. Many database administrators are fully aware of the power of indexes and know how to create them. However, I find that some have yet to dive into fully optimizing their indexes and taking advantage of what filtered indexes has to offer. What is a filtered index? Simply it’s an index with a where clause. It is an optimized non clustered index that can be narrowed down in scope to better fit a subset of data.… Continue Reading