Groups > comp.lang.java.databases > #727

Re: Getting the size of a result set

From	Arne Vajhøj <arne@vajhoej.dk>
Newsgroups	comp.lang.java.databases
Subject	Re: Getting the size of a result set
Date	2016-02-15 12:53 -0500
Organization	Aioe.org NNTP Server
Message-ID	<n9t3a6$sjv$1@gioia.aioe.org> (permalink)
References	<MPG.1509c1b149b07f85989c26@10.1.1.51> <3AA7BB0C.3E29B600@sea.ericsson.se> <66367974-130d-4a9d-a06a-db1611553af2@googlegroups.com>

Show all headers | View raw

On 2/15/2016 12:15 PM, jagilberte@gmail.com wrote:
> El jueves, 8 de marzo de 2001, 18:02:04 (UTC+1), Valentin Todorov  escribió:
>> Try this:

> Hi, if you want to make a count of rows is better always use COUNT(1) than
> COUNT(*). Because the * implies project all the atributes and the 1 avoid project the attributes.

1) The thread you are replying to is 15 years old.

2) Your advice is *not* universally accepted. Most databases seems to
    do the same for the two.

Arne

Back to comp.lang.java.databases | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: Getting the size of a result set jagilberte@gmail.com - 2016-02-15 09:15 -0800
  Re: Getting the size of a result set Arne Vajhøj <arne@vajhoej.dk> - 2016-02-15 12:53 -0500
  Re: Getting the size of a result set Rhino <no_offline_contact@example.com> - 2016-10-16 21:49 -0400
    Re: Getting the size of a result set Arne Vajhøj <arne@vajhoej.dk> - 2016-10-19 23:50 -0400

csiph-web