Speeding up the Performance of Table Counts in SQL Server 2005

Wednesday Sep 17th 2008 by DatabaseJournal.com Staff
Share:

This article describes how the Object Catalog Views can be used to determine the number of rows in a table.

[From SQL Server Performance]

When we want to get the row count of a table, we use the transact-SQL function count (*). In the case of large table which may contain millions of rows, it can take a long time to return the row count of the whole table, and that leads to slow performance for the query.

The article continues at http://www.sql-server-performance.com/articles/per/Speeding_up_the_Performance_of_Table_Counts_p1.aspx

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved