Search code examples
sql-serverssmsssms-2012

How do i get the execution time of an View


I created a view for testing purposes and would like to see the execution time.

But i was unable to find an option to do this could somebody please guide me how i could get this information.


Solution

  • little easy way

    set statistics time on
    
    select * from [dbo].[ViewName]
    
    set statistics time off
    

    then see your message window

    enter image description here

    For more information of Query Execution Plan