Reputation: 5420
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
Reputation: 3342
little easy way
set statistics time on
select * from [dbo].[ViewName]
set statistics time off
then see your message window
For more information of Query Execution Plan
Upvotes: 3