Timing sql queries

DECLARE @t1 DATETIME;
DECLARE @t2 DATETIME;

SET @t1 = GETDATE();
SELECT /* query one */ 1 ;
SET @t2 = GETDATE();
SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms;

SET @t1 = GETDATE();
SELECT /* query two */ 2 ;
SET @t2 = GETDATE();
SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms;

Timing sql queries

SELECT GETDATE();
SELECT /* query one */ 1 ;
SELECT GETDATE();
SELECT /* query two */ 2 ; 
SELECT GETDATE();

-1

Source: stackoverflow.com

Similar codes

2 votes217 views1 answer
Date conversion in mysql column
SQL
0 vote222 views1 answer
Flush user resource mysql
SQL
0 vote215 views1 answer
Install postgresql 12 on debian 10
SQL
1 vote249 views1 answer
Mysql view curren querys
SQL
3 votes215 views1 answer
Apex set debug level
SQL
0 vote323 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote226 views1 answer
Mysql récupérer le code création de vue
SQL
1 vote204 views1 answer
Oracle lowercase
SQL
3 votes209 views2 answers
Plsql print
SQL
-1 vote217 views2 answers
Postgresql user permissions to database
SQL