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?

Regards,
Reynaldi