What is Filtered Index in SQL
| This index is used when we have to index some of rows in table this helps to increase performance and also reduce cost done by index on all the rows.When we see an Index created with some where clause then that is actually a FILTERED INDEX. | |