[SQL Server] How To test execution efficiency (time)

DBCC dropcleanbuffers
DBCC freeproccache
Set statistics time on
; With T
(
Select 1 as num
Union all
Select num + 1
From t
Where num <100000
)
Select * from t
Option (maxrecursion 0)
Set statistics time off
/*
DBCC execution is complete. If DBCC outputs an error message, contact the system administrator.
DBCC execution is complete. If DBCC outputs an error message, contact the system administrator.
 
....
(Row 3 is affected)
 
SQL Server execution time:
CPU time = 5518 milliseconds, occupied time = 42845 milliseconds.
*/