Really nice question. I even did the research on each option, but somehow missed the line about indexed views. Looks like I need to brush up on my options!
(And I will smack the first guy who says "Thanks for the easy question to end the week!") 😉
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown