Subject Re: My query plan does not use correct index
Author reynaldi81
Thanks for your response. Actually, my indexes is not that many. I was just trying to find a best one for my queries. I will delete most of them after.

Back to my problem.

It seems that if i removed the "order by" clause, the query works very fast. So it must be that order by part that consumes all the performance. Any idea how to fix this?