Answer
A filtered index stores only rows matching a condition.
It reduces index size and improves seek performance for selective queries.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ