is there a system table with the rowcount of each table?

[ck9663]

i found the sys.partition view. i can access it if i am in the same database. if i am in a different database, it does not allow me to do a db.owner.sys.partition form of reference.

am just trying to get the table rowcount with using a select @row_count_var = count(*) from mytable. i was thinking accessing the system view would be faster. any idea guys?

thanks

[ck9663]

i found the sys.partition view. i can access it if i am in the same database. if i am in a different database, it does not allow me to do a db.owner.sys.partition form of reference.

am just trying to get the table rowcount with using a select @row_count_var = count(*) from mytable. i was thinking accessing the system view would be faster. any idea guys?

thanks

found it....sysindexes

[shaileshb]

according to my know there r only tow ways

1) Count()

but if ur tables contains lacks of records then count will take considerable amount of time to execute ur query, the other way is

2) ShowStatastics : give u table information including no. of rows