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

0 vote186 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote196 views1 answer
Apex select list ORA-20999
SQL
0 vote194 views2 answers
Return the number of records in a single table mysql
SQL
0 vote207 views1 answer
Calculate age in sql
SQL
0 vote201 views1 answer
Restart sql server command line linux
SQL
0 vote212 views2 answers
Call to undefined function mysql_query()
SQL
3 votes216 views5 answers
Foreign keys
SQL
4 votes196 views3 answers
Mysql update with join
SQL
0 vote188 views1 answer
Get who is hired in specific month in sql
SQL
0 vote188 views1 answer
Install mysql for fedora 34
SQL