Dear all

I am using SQL-Server database,
but i have a strange problem,
I have one Visual Basic application which query from database
every 100 ms. The query is very simple like:

select top 10 *
from tableX

Everything is OK, but when i add 'order by' clause,
the CPU-usage of my database server become very high,
i just changed the query to:

select top 10 *
from tableX
order by number

Anybody can help me, please ?

thanks
Agus