HTML Database Doc Script

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

The data in the system tables that indicates # of rows is not kept up to date real time, it is only updated when statistics are updated.

So the numbers will be correct only immediatelly after updating statistics. otherwise they are only used as "Estimates" for the query optimizer.

Hence the reason you have to update stats when query plans are not efficient. Especially if the db option autoupdate stats is off.

awdiwo Grasshopper Points: 21 More actions · Answer 2

Thanks. We update rowcount stats nightly. He says this is something else.

Ray M SSC-Insane Points: 21093 More actions · Answer 3

Well, if you update stats, and records continue to pour into the table, the stats are a point in time count. Not a running count.

Or this

Good Reading