I have a table with 2 columns which I have a non clustered index on it in the form of column a asc , column b asc .
I ran the below 2 quires against this table and found that only query 1 utilizes index seek while the 2 query is using index scan.
This have forced me to create a second index in the form of column b asc , column a asc to get index seek for both queries
query 1: select column a from table x where column b = x
query 2: select column b from table x where column a = x
So my question here could I use 1 index to cater for both queries?