Friday, October 9, 2009

Counting rows in a table for improving performance of the query

Below is the query for counting rows in a table for improving performance of the query.
SELECT rows FROM sysindexes WHERE id = OBJECT_ID('tbl_xyz') AND indid less than 2

No comments:

Post a Comment