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.