count is very slow

CREATE NONCLUSTERED INDEX NCFIX_Table1_Test01
    ON Table1 (ID)
    WHERE Name='';
GO

Try with this one and share with us execution plan

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it