sql server – Multiple Indexes and Tuning


Let’s say I have columns A-F and the following indexes. I’m azure Azure SQL Database 2019.

Primary Key: A

Index 1: B (ASC),C (ASC)

Index 2: B (ASC)

If I wanted to run run the following query below, is Index 2 needed or could it use Index 1 and not impact on performance?

SELECT A,B,C,D,E FROM table WHERE B = 'X'.

Thanks.