SQL Server 2008 Question: Download Questions PDF
Explain filtered indexes?
![MS SQL Server 2008 Interview Answer MS SQL Server 2008 Interview Question](https://globalguideline.com/public/images/interview/28.png)
Answer:
Filtered index in SQL Server 2008 is an index WHERE clause. A filtered index is an optimized non-clustered index. It allows for defining the filter predicate with WHERE clause at the time of creating index. The rows from the filtered index are available in B-Tree will contain the rows which only satisfy the criteria of the filter while creating the index.
Download MS SQL Server 2008 Interview Questions And Answers
PDF
Previous Question | Next Question |
What is MERGE? | Explain filtered indexes benefits? |