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

3 votes312 views3 answers
Docker create postgresql database
SQL
1 vote312 views1 answer
Jooq convert using gbk
SQL
0 vote312 views1 answer
QUERY JPQL
SQL
1 vote328 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote349 views1 answer
Oracle chain step succeeded
SQL
3 votes304 views3 answers
Mysql order by list
SQL
0 vote315 views1 answer
Transaction database with php
SQL
2 votes302 views1 answer
How to make insert script from table in SQL server
SQL
0 vote347 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote285 views1 answer
Java mysql date format
SQL