Hi,
A colleague of mine came across a strange scenario, picture this.
We have a table called TableA, it has a handful of records in it, lets say 7.
A user runs a delete statement to remove 1 record.
Another users runs a select to return the contents of the table but they get zero records returned.
All very odd you may think, however if a user then runs a stat update on the table, then the second user re-runs their select, they then get the 6 records back, as expected.
I've never seen this before, does anyone know why this would happen?
Thanks,
Nic