Stewart "Arturius" Campbell (12/20/2012)
However, it could be that the PO intended that the use of filtered index(es) is implied (or should be assumed)...
Maybe, but my crystal ball is in the shop for repairs, so unless the OP mentions it, there's no need to assume it. 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP