db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Slow performance of select count(*) from a_table
Date Tue, 07 Oct 2008 10:55:03 GMT
Tim Dudgeon <tdudgeon@informaticsmatters.com> writes:

> I have a large table (24 million rows) and getting the row count with
> select count(*) from a_table is taking about 50 seconds.
> This seems surprising to me. Surely Derby is not going through every
> row and counting them?

Hi Tim,

I think that's how count(*) is implemented currently.

Knut Anders

View raw message