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.