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 vote182 views1 answer
Java mysql swing example
SQL
0 vote191 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote177 views1 answer
Min mysql
SQL
1 vote276 views1 answer
How to select the nth row in a SQL database table?
SQL
2 votes175 views1 answer
Get first n letter of department name in sql
SQL
0 vote202 views1 answer
Insert value in identity
SQL
0 vote186 views1 answer
Create column that already exists mysql
SQL
0 vote227 views1 answer
Sql server current time without date
SQL
11 votes172 views1 answer
Mysql order by two columns priority
SQL
2 votes190 views2 answers
Postgresql search all tables for column name
SQL