On 5/18/07, Jessica Richard <[EMAIL PROTECTED]> wrote:
I have a ~30 milliow row table, select count(*) from this table is very very very slow...
Yes, see the topic "Much Ado about COUNT(*)"
How dow I get it run faster?
Unfortunately, aside from reducing the size of the table, you can't. -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 3rd Floor | [EMAIL PROTECTED] Iselin, New Jersey 08830 | http://www.enterprisedb.com/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
