SQL> select count(*) from ysgl_compile_reqsub;

   COUNT(*)

 ----------

    5288265

 已用时间:  00: 00: 07.51

 SQL> select count(1) from ysgl_compile_reqsub;

   COUNT(1)

 ----------

    5288265

 已用时间:  00: 00: 00.68

 SQL> select count(id) from ysgl_compile_reqsub;

  COUNT(ID)

 ----------

    5288265

 已用时间:  00: 00: 00.68

 SQL> select count(rowid) from ysgl_compile_reqsub;

 COUNT(ROWID)

 ------------

      5288265

 已用时间:  00: 00: 01.01

 SQL> select count(rowid) from ysgl_vdata_his;

 COUNT(ROWID)

 ------------

      5299458

 已用时间:  00: 00: 09.98

 SQL> select count(*) from ysgl_vdata_his;

   COUNT(*)

 ----------

    5299458

 已用时间:  00: 00: 00.93

 SQL> select count(1) from ysgl_vdata_his;

   COUNT(1)

 ----------

    5299458

 已用时间:  00: 00: 00.71

 SQL> select count(1) from ysgl_excelbasic;

   COUNT(1)

 ----------

    3755052

 已用时间:  00: 00: 04.60

 SQL> select count(*) from ysgl_excelbasic;

   COUNT(*)

 ----------

    3755052

 已用时间:  00: 00: 00.50

 SQL>