SET STATISTICS TIME ON – SQL in Sixty Seconds 139

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)

Menu
Exit mobile version