T-SQL Tips‎ > ‎

"Select Count" Replacement

Is your database server currently host very large database and grow rapidly ? If yes, how do you efficiently use "select count" statement ? You don't need to use that "set based" query. Here's how you do it alternatively.


SysIndex : SQL Server 2000 / 2005 / 2008

sysindexes & sysobjects

USE [PHI-Minimart];

DECLARE @TableName varchar(100);

SET @TableName = 'tr_penjualan';

SELECT so.name as table_name, si.rowcnt as count_of_rows
FROM 
sysindexes AS si
INNER JOIN 
sysobjects AS so ON si.id = so.id
WHERE si.indid < 2 AND OBJECTPROPERTY(so.id, 'IsMSShipped') = 0 and so.NAME=@TableName;

or

SELECT so.name as table_name, si.rowcnt as count_of_rows
FROM 
sysindexes AS si
INNER JOIN 
sysobjects AS so ON si.id = so.id
WHERE si.indid < 2 AND OBJECTPROPERTY(so.id, 'IsMSShipped') = 0 and so.NAME='your-table-name';

Download Code


Comments