SET STATISTICS TIME ON – SQL in Sixty Seconds 139

SET STATISTICS TIME ON - SQL in Sixty Seconds 139 139-TIMEIO-yt-800x450 Do you know how long your query took to execution? Well, let us learn that today in today’s quick episode of SQL in Sixty Seconds. We will discuss SET STATISTICS TIME ON.

Earlier I blogged about SET STATISTICS IO ON – SQL in Sixty Seconds #128 and during that blog post I discussed how we can measure the IO for any query. Similarly, it is important to also learn how to measure the time taken by any query.

In this SQL in the Sixty Seconds video, we will learn how SET STATISTICS TIME ON works.

The command to enable TIME is as follows:

SET STATISTICS TIME ON

Here are a few recent SQL in Sixty Seconds Video:

If you like what you see, I request you to subscribe to my YouTube Channel, where I discuss many such topics which you may find interesting. If you like any video on YouTube, you can always go back to your YouTube History and find the same video again easily.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
Single Installer for SSMS and ADS – SQL in Sixty Seconds #138
Next Post
Performance Challenge – Write Efficient Query – SQL in Sixty Seconds #140

Related Posts

Leave a Reply

Menu