Re: Index to speed up "select count(*) from" queries...

Tim,
  do a count(ROWID)

Regards
Dante

In article <7hop3v$5me$1_at_nnrp1.deja.com>,   tim_mcconechy_at_my-dejanews.com wrote:
> My application needs to do some count(*) queries...
>
> Is there some kind of index I can use to speed this query..
>
> On a table with 100000 records it takes a couple seconds longer than I
> would like...
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 17 1999 - 05:00:14 CDT