"Filtered Indexes for Reporting"

1. What is a filtered index?

An index that includes all table rows A nonclustered index with a WHERE clause An unfiltered index with indexes on all columns A clustered index that includes multiple tables

2. Which of the following situations is most suitable for using a filtered index?

A table where many rows have the same value in a column A table where every row has unique values in all columns A table with predominantly closed orders but a few open orders A table with multiple foreign key relationships

3. What is one of the main conditions for a filtered index to be used effectively?

The filter condition can be based on multiple tables The filter column should rarely appear in queries The query predicate must be provably covered by the filter The filter condition must involve a complex computation

4. What is the purpose of creating filtered statistics without an index?

To speed up grouped queries To create a smaller version of the table To improve estimates for a specific slice of data To enforce unique constraints on rows

Continue: "Statistics, Fragmentation, and the Cost of Writes" → Review this lesson Retake quiz