crazywolf2010
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://msdn.microsoft.com/en-us/library/ms188917.aspx