InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Filtered Index? |
|
Answer» 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. 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. |
|