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]>: > 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]. > 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]. 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.
