On 07/08/2013 20:21, Steve Wiser wrote:

> Do you have automatic sweeps turned on? Not sure if that matters or not.
>
> If not, maybe run the gfix sweep command and try your select count again.

I understand that we tried running a sweep but it didn't make any
difference.

But even if it's a sweep that's needed, we still don't understand why
that would, apparently, cause the database to re-read the same pages 100
times.

--
Tim Ward