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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance problems with large table

Re: Performance problems with large table

From: Chrysalis <cellis_at_clubi.ie>
Date: 1998/03/31
Message-ID: <cellis-ya02408000R3103981855270001@news.clubi.ie>#1/1

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?
  2. Have you tried it?
  3. If so, we would be interested in your results
  4. If not, please don't post stuff like this.
-- 
Chrysalis

"FABRICATE DIEM PVNC"
(To to protect and to serve)
Motto of the City Guard
Terry Pratchett
Received on Tue Mar 31 1998 - 00:00:00 CST

Original text of this message

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