> My next question is that does this kind of query optimezed the
> uses of Index? What about its performance in non index columns?

You can always verify usage of indexes yourself, just look at plan generated
for each query. E.g. in ISQL use this commnad
SET PLAN ON;
and then execute your query.

Ivan