WiiMaxx
WiiMaxx

Reputation: 5420

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.

Upvotes: 0

Views: 139

Answers (1)

wiretext
wiretext

Reputation: 3342

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

Upvotes: 3

Related Questions