November 6, 2002 at 6:47 pm
Hello
When I run a trace I see that SQL Server is doing 15 reads even though the table is empty?
the query is select field from table(nolock) where id =1
I re-compiled the query --> still the same
I copied & renamed the query --> the copy takes only 6 reads
I am afraid to clear the processor cache (this is a production system)
Can any one suggest something?
Thank you
Dave Mickle
November 6, 2002 at 7:11 pm
Can you post the query. Also, take a look at the execution plans of both and see if anything specific is happening that is different? Finally, if the views are in the same database it is unusual to have the same views run differently unless one is used very often then a recompile might help, you said you did this, exactly how? If nothing else drop it and replace back, however this may be what you already have done based on your information. Another thing might be to try to run sp_updatestats for the table and DBCC UPDATEUSAGE, may be something reporting bad information.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply