How indexes are used with COUNT in SQL Server

Tag: performance tuning