Link to home
Start Free TrialLog in
Avatar of Charles Baldo
Charles BaldoFlag for United States of America

asked on

Faster way to get row count from a view than select Count(*) from ViewObject?

Is there a faster way to get a row count from a view than select count(*) from ViewName??

Migrating a massive, humongous doc management system out of SQL 2005 and need to get row counts. Almost a billion records and the last count took 20 minutes.

"No" is an acceptable answer if you are 100% sure.
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Charles Baldo

ASKER

It is thanks, close is good enough as well, the database is static and not changing now.