How to locate number of rows without firing select count(*) query

Hi,
I have 4-5 massive BI tables where the records are in hundreds of millions. I can't fire select count(*) as that will take next 4-5 hours to return results from these tables. The server is already overused.

I can see the query is estimating the execution plan & rows. Is there is an internal optimizer table from where I can get apprx number of rows at each table?

Thanks

Microsoft SQL Server 2008Microsoft SQL Server 2005

Last Comment

Ramesh Babu Vavilla

8/22/2022 - Mon

jogos

3/20/2012

In the DMV sys.dm_db_index_physical_stats and there the record_count, but read comment on this at
http://msdn.microsoft.com/en-us/library/ms188917.aspx

ASKER CERTIFIED SOLUTION

Ramesh Babu Vavilla

3/20/2012

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Your help has saved me hundreds of hours of internet surfing.