See the compile time

use <mydatabase>
go

dbcc freeproccache
go
checkpoint
go

set statistics profile on
go
set statistics io on
go
set statistics time on
go
select 'starting time: '
select getdate()
go

<insert your SQL here>

go
select 'ending time: '
select getdate()
go
set statistics profile off
go
set statistics io off
go
set statistics time off
go