The above query is good, but it will give the accurate count all the time. Since it takes the count using the index.
It depends on the index how you created.
If you need more info on this check msdn help on indexes and rowcount of sysninexs table.
sorry for the typo.. it should be....
The above query is good, but it will [font="Arial Black"]not[/font] give the accurate count all the time. Since it takes the count using the index.
It depends on the index how you created.
If you need more info on this check msdn help on indexes and rowcount of sysnindexs table.