Home > DeveloperSection > Interviews > What is Filtered Index in SQL?

Posted on    August-21-2014 12:06 AM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  821  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Points:3910
Posted on    August-21-2014 12:00 AM

Filtered Index is used to index a portion of rows in a table that means it applies filter on INDEX which improves query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes. When we see an Index created with some where clause then that is actually a FILTERED INDEX.


Don't want to miss updates? Please click the below button!

Follow MindStick