You see things; and you say 'Why?' But I dream things that never were; and I say 'Why not?'

Monday, February 9, 2009

To get the row count in a faster way

To get the row count in a faster way , the conventional way would be very slow.

SELECT rows FROM sysindexes
WHERE id = OBJECT_ID('TABLEA') AND indid < 2

TABLEA : Is the name of the table

No comments:

Followers