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'.