SQL大数据操作统计

SQL大数据操作统计

1：select count(*) from table的区别
SELECT object_name(id) as TableName,indid,rows,rowcnt

FROM sys.sysindexes WHERE id = object_id('TableName')

and indid in (0,1);