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