count(*) 与count(1)的效率

使用count(*) 与count(1)的效率，大部分是count(1)效率高，count(*)效率低，具体原因待查

 

db2inst2@gd1:~> time db2 "select count(*) from OT_JNL_VERIFY"

1          
-----------
  225919230

  1 record(s) selected.


real    8m7.084s
user    0m0.016s
sys     0m0.012s
db2inst2@gd1:~> time db2 "select count(1) from OT_JNL_VERIFY"

1          
-----------
  225914539

  1 record(s) selected.


real    6m46.074s
user    0m0.016s
sys     0m0.012s



db2inst2@gd1:~> time db2 "select count(*) from  OT_JNL_QUERY"

1          
-----------
   40924380

  1 record(s) selected.


real    1m45.073s
user    0m0.008s
sys     0m0.020s
db2inst2@gd1:~> time db2 "select count(1) from  OT_JNL_QUERY"

1          
-----------
   40924338

  1 record(s) selected.


real    1m25.203s
user    0m0.008s
sys     0m0.020s

db2inst2@gd1:~> time db2 "select count(*) from  FT_USER_MER_CTRL"

1          
-----------
    4421292

  1 record(s) selected.


real    0m7.255s
user    0m0.012s
sys     0m0.020s
db2inst2@gd1:~> time db2 "select count(1) from  FT_USER_MER_Ctrl"

1          
-----------
    4421305

  1 record(s) selected.


real    0m5.626s
user    0m0.012s
sys     0m0.012s

 

转载于:https://www.cnblogs.com/atwanli/articles/4962380.html