There is a non-clustered index IX_available on table T. I have created a duplicate index IX_ Now can you tell me which is the index is chosen by query optimizer and why?

[Isaiah]

Hello, I would like to ask you a very special question, there is a non-clustered index ix_available on table t. i have created a duplicate index ix_ now can you tell me which is the index is chosen by query optimizer and why? Thank you for giving me an answer please by return message.