Yes, that simple question is, in the modern Nvidia world that has come to dominate AI training and to a certain extent HPC simulation and modeling, heretical. But given that CPUs are in many cases ...
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 ...