I have a table above 8.000.000 records. I am running a query like
"select * from table where id=1093203". And the query turns in 24 second. This example i tested in SQL Server 2000 v8, Windows 2003 sp2.
I am running same query in Windows Xp + Sql server 2005 platform. The query returns about 2 second.
The first platform which i explained top is better hardware than second one. Also there isnt any cpu or ram overload problem. Everything seems ok. But i dont understand what is the problem. Could you help me to solve this?