WHAT IS FILTERED INDEX IN SQL?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
 1037  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    What is Filtered Index in SQL?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!