Loading

Problem with the query

srinivas rao

17y2.7k

I am using sqlserver 2000.When i run a query for the first time..it is executing in particular time like 12 sec and when i am executing the same query the next time,it is executing in more or the less time like 4 sec,14sec. If the time varies like this, my application doesn't work well. Can you give any solution for this problem?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Roei Bar17y ago
Accepted answer
well my friend, this time is way way to much for a select, and the various time indicate that you have deadlocks on the tables that you are running the select on, or you are missing some indexes.

can you provide some details on the rows count in each table, total size of the DB, number of tables in the select query, keys and indexes.

if you could provide the Query with some information on the tables it would be even easier