| Subject | Why does it take hours to perform a select count(*) on a table with 586,000 recs |
|---|---|
| Author | nathanawork |
| Post date | 2006-02-24T14:29:32Z |
I have a table with 586,000 records. When I try to get a record count
using select count(*) from table, it takes hours. Why is this? How can
I get a quick count?
using select count(*) from table, it takes hours. Why is this? How can
I get a quick count?