怎样最快得到数据库某个表中的数据总数？

如题
---------------------------------------------------------------

SQL="select count(*) as num from table1"
Set rs=conn.execute(SQL)
Response.Write(rs("num"))

rs("num")就是总个数
---------------------------------------------------------------

select count(*) as cc from tablename
---------------------------------------------------------------

如上
---------------------------------------------------------------

rs.recordcount