Postgres Pro
Downloads
Home   >   mailing lists

Thread: COUNT

COUNT

From
"Lufkin, Brad"
Date:
I'm trying to determine the number of rows in a table with the following
statement:

    ResultSet resultSet = statement.executeQuery("SELECT COUNT(*) FROM
table");

This is apparently causing a sequential scan of the table (which has several
million rows). Is there a faster way of  determining the number of rows in a
table?