Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Tunning
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...Received on Thu Jan 25 2001 - 07:57:43 CST
> > 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
>