Re: Performance problems with large table

Hello,

Chrysalis wrote:
>
> In article <35211C44.CC223CEC_at_spb.runnet.ru>, Igor Sereda
> <sereda_at_spb.runnet.ru> wrote:
>
> > Hello,
> >
> > I think that
> > SELECT COUNT(ROWID)
> > will perform better than
> > SELECT COUNT(*)
> >
> > Regards,
> > Igor
> >
> > Ing. Martin Gamperl wrote:
> > >
> > > snip
>
> 1) Why do you think this?

Because i usually think.

> 2) Have you tried it?

Yes.

> 3) If so, we would be interested in your results
I ran stress test on Oracle 7.3.2 under Solaris 2.5.1 x86 (specially for you).
When using SELECT (ROWID) Oracle shows x1.5 improvement of performance (in tpM) than SELECT (*). I hope to satiate your interest.

> 4) If not, please don't post stuff like this.
Why can't i post _what_i_think_? I didn't state that it is absolute truth.

And now:

1. Do you consider yourself a polite person?
2. If yes, i recommend you to revise your messages style.
3. If not, please don't post your messages in discussions.

PS.
To the others: Sorry for flame.

Best regards,
Igor Sereda

>
> --
> Chrysalis
>
> "FABRICATE DIEM PVNC"
> (To to protect and to serve)
> Motto of the City Guard
> Terry Pratchett

--
Igor Sereda,
ITC, Russia