Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dave62 What's the best way to count? RE: What's the best way to count?

  • October 19, 2010 at 4:59 am

    #1238940

    dave.farmer (10/19/2010)

    Does anyone know if there's a similar fast count method for views?

    Only if they are indexed. Or if the relationships between the underlying tables are such that you can derive the number of rows in the view from the number of rows in the tables.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/