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.
Join MindStick Community
You need to log in or register to vote on answers or questions.
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy.
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.