Category: retrieve filtered indexes

Filtered indexes were introduced from SQL Server 2008 . Its a special type of Non Clustered index with a filter applied. This comes particularly handy in cases where we’e interested in only some subsets of data more frequently in a…