Problem with the query

Question

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 timeit is executing in more or the less time like 4 sec14sec. If the time varies like this my application doesn't work well. Can you give any solution for this problem?

Roei Bar · 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