| Subject | Count(*) on big tables | 
|---|---|
| Author | Jerome Bouvattier | 
| Post date | 2004-05-05T14:44:32Z | 
Hello,
I know Count(*) requires a full scan and can't return immedialtely. But
isn't 8 minutes a bit too much for a 50 millions rows table ?
The first time, I thought it was due to GC, but subsequent calls took as
long.
Any hint ?
Thanks.
--
Jerome
            I know Count(*) requires a full scan and can't return immedialtely. But
isn't 8 minutes a bit too much for a 50 millions rows table ?
The first time, I thought it was due to GC, but subsequent calls took as
long.
Any hint ?
Thanks.
--
Jerome