Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index to speed up "select count(*) from" queries...
hi....
The query is always single table.. Something like... select count(*) from articolr;
I tried :
select count(recno) from articolr; (4 secs) select count(*) from articolr; (3 secs) select count(rowid) from articolr;(3 secs)
But all seem the same..
Articolr has 100000 records and a PK called recno...
In article <7hoqsa$6rh$1_at_nnrp1.deja.com>,
Dante <dnotari_at_my-dejanews.com> wrote:
> 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.---
>
--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 17 1999 - 06:13:01 CDT