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: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/04/01
Message-ID: <6ft8r1$lcc$3@news02.btx.dtag.de>#1/1

Hi,

3) Can you proove the contrary
4) Free speach. Don't discourage people from posting even if they are wrong. Live is for learning.

On Tue, 31 Mar 1998 18:55:27 -0700, cellis_at_clubi.ie (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?
>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

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de
Received on Wed Apr 01 1998 - 00:00:00 CST

Original text of this message

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