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

Tim,
  sorry ... forget my reply ... that is nonsense ...

  Are you using single table columns or joins ? Could   you provide the query ?

Regards
Dante

In article <7hopbe$5oo$1_at_nnrp1.deja.com>,   Dante <dnotari_at_my-dejanews.com> wrote:
> 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.---
>

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