Hi Danny,
I use sql server 2012,for count(1) query will improve a lot because it
just return row_number
在 2018年8月28日星期二 UTC+8下午5:04:09，Danny Van den Wouwer写道：
>
> Good database software knows that if you use the aggregate function
> count(*) you don't want to retrieve internally all fields of all the
> involved tables. So count(*) might even be slightly faster then count(1)
> in those cases. It is not a good idea to change this behaviour to count(1).
> Can you tell me which database server you using?
>
> Vriendelijke groeten,
> Van den Wouwer Danny
>
> Software Engineer
> Peopleware NV
> www.peopleware.be
>
> Op di 28 aug. 2018 10:42 schreef Ricardo Peres <[email protected]
> <javascript:>>:
>
>> Yes, COUNT(1) and COUNT(*) are exactly the same.
>>
>> RP
>>
>> On Monday, August 27, 2018 at 10:08:02 PM UTC+1, Gunnar Liljas wrote:
>>>
>>> It's certainly possible, but I don't understand why it would be an
>>> advantage.
>>>
>>> /G
>>>
>>> Den mån 27 aug. 2018 kl 22:55 skrev Ricardo Peres <[email protected]>:
>>>
>>>> I agree. Why don't you create an issue on
>>>> https://github.com/nhibernate/nhibernate-core? Maybe someone can pick
>>>> it up.
>>>>
>>>> RP
>>>>
>>>> On Monday, August 27, 2018 at 10:56:55 AM UTC+1, 郭骞 wrote:
>>>>>
>>>>> Hi All,
>>>>> is it possiblle for nhibernate query count sql generated not
>>>>> select count(*) but count(1) ?
>>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "nhusers" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to [email protected].
>>>> To post to this group, send email to [email protected].
>>>> Visit this group at https://groups.google.com/group/nhusers.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "nhusers" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> To post to this group, send email to [email protected]
>> <javascript:>.
>> Visit this group at https://groups.google.com/group/nhusers.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
