Path: csiph.com!aioe.org!.POSTED!not-for-mail From: =?UTF-8?Q?Arne_Vajh=c3=b8j?= 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: References: <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 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