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

Re: Getting the size of a result set

Path	csiph.com!aioe.org!.POSTED!not-for-mail
From	Arne Vajhøj <arne@vajhoej.dk>
Newsgroups	comp.lang.java.databases
Subject	Re: Getting the size of a result set
Date	Mon, 15 Feb 2016 12:53:11 -0500
Organization	Aioe.org NNTP Server
Lines	15
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>
NNTP-Posting-Host	ANasIS7Js9OyLQwgloeBLQ.user.gioia.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding	8bit
X-Complaints-To	abuse@aioe.org
User-Agent	Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Thunderbird/38.5.1
X-Notice	Filtered by postfilter v. 0.8.2
Xref	csiph.com comp.lang.java.databases:727

Show key headers only | 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