This query is given to me by the developer, so i dont know why he is using this convert statemens.

i created a covering index for table T1,but still it uses...

I am new to sql server. Can you please how to create a covering index? on whic columns?

Thanks for your suggestion. The query is performing ok.