Query optimizer doesn't consider the index in the execution plan for any Transact-SQL statements. For more information about filtered indexes, see Create filtered indexes and the SQL Server index ...