Yes you are right .A bit strange (to us that why the index that is created second is used)..but there might be some logic we dont know .

main thing is , will it perform the same way once some good amount of data is in inside the table .

I have not done any stuff to populate this table .

Might try , but very occupied as of now .

Regards