Explain filtered indexes benefits?
Submitted by: AdministratorThe benefits of Filtered indexes are:
Has only that row which satisfies the filter criteria defined. This results in reducing the storage space need for the index.
The filtered index statistics are accurate and more compact. The reason is they consider only the tuples / rows in the filtered index and it reduces the cost of overhead of updating the statistics.
The data modification impact is less by using filtered index. Because it is updated only at the time where the data of the index is impacted.
The cost of maintenance will be reduced, because only the subset of rows will be considered which rebuilding the index.
Submitted by: Administrator
Has only that row which satisfies the filter criteria defined. This results in reducing the storage space need for the index.
The filtered index statistics are accurate and more compact. The reason is they consider only the tuples / rows in the filtered index and it reduces the cost of overhead of updating the statistics.
The data modification impact is less by using filtered index. Because it is updated only at the time where the data of the index is impacted.
The cost of maintenance will be reduced, because only the subset of rows will be considered which rebuilding the index.
Submitted by: Administrator
Read Online MS SQL Server 2008 Job Interview Questions And Answers
Top MS SQL Server 2008 Questions
☺ | What is Table Value Parameters (TVP)? |
☺ | Explain filtered indexes? |
☺ | What is Intellisense? |
☺ | What is Compound Operators? |
☺ | What is MERGE? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |