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: SQL Tunning

Re: SQL Tunning

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 25 Jan 2001 13:57:43 -0000
Message-ID: <94pbcr$7lh$1@soap.pipex.net>

I don't believe that this last is true anymore.(as of 8i certainly but probably 8x).

for example on on of our databases, after a couple of repetitions I get

SQL> select count(1) from aglrelvalue;

  COUNT(1)


   2572566

Elapsed: 00:00:01.42
SQL> select count(*) from aglrelvalue;

  COUNT(*)


   2572566

Elapsed: 00:00:01.42

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3A6FB5D2.FD584499_at_exesolutions.com...

> > we're starting tunning for the provider application and we've a doubt.
> > When a "select count(*) " sentence generally returns zero, how will be
> > the performance over a large table?
>
> Could you please repeat your question with a bit more detail. I am having
> a hard time understanding what you are asking.
>
> Also, generally select count(1) is faster than select count(*).
>
> Daniel A. Morgan
>
Received on Thu Jan 25 2001 - 07:57:43 CST

Original text of this message

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