Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Index to speed up "select count(*) from" queries...

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

From: <tim_mcconechy_at_my-dejanews.com>
Date: Mon, 17 May 1999 11:13:01 GMT
Message-ID: <7hotjs$8cb$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US