Knut Anders Hatlen wrote:
Tim Dudgeon <[EMAIL PROTECTED]> 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.
So can this be optimised? Should I submit a RFE? Thanks Tim
