What is Filtered Index?

Posted by

To view Verified answers click on the button below.

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.