Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
 Posted - 2004-09-20 : 18:37:12
|
Is their a faster way to get record counts from the tables thanSelect Count(*) from xI have some rather large tables and EM seems to "know" the record counts when you double click on a table? Surf On Dude! |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-09-20 : 19:09:29
|
| Have a look at sp_spaceusedThe "fast" table counts are read from sysindexes, but is not "reliable"rockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
 |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-09-20 : 19:13:42
|
| Thank you Tested... I see what you mean...Surf On Dude! |
|
|
|
rukkur
Starting Member
10 Posts |
Posted - 2004-09-21 : 06:54:12
|
| Instead of Count(*) Use Count(1) will be faster |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-09-21 : 08:23:12
|
quote:
Originally posted by rukkur
Instead of Count(*) Use Count(1) will be faster
That is not the caserockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
|
|
|
|
|
|
Getting Record Counts