Is there any way to see query execution time ( like 1 sec or 0.4mm) for join/ index scan/ seek in SQL 2016 ? is it related to SSMS version? please advise. I tried with SSMS 11.0 and v17.1
Before your query, put SET STATISTICS TIME ON, and after the query, put SET STATISTICS TIME OFF. On the messages tab, it will tell you how long each component took (if there are separate statements) and overall time.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply