MS SQL Server - Inconsistent logical read for same query

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Inconsistent logical read for same query

james

2006-10-24, 6:31 pm

Hi! I am in the process of tuning a stored procedure and came accross
something rather unusual.
Basically, the number of logical reads against a table keeps on changing
before and after I run Dbcc drop cleanbuffers even though the execution plan
is completly identical.
I understand that physical reads will be different after cache is flushed
out but why logical read get changed after flushing the cache but with exact
same execution plan.

Anybody has seen this behavior and possible explanation for it. Sql 2000 SP4

Sponsored Links