###### tags: `Sql`,`2022`

#SQL 監測IO、時間效能

SET STATISTICS TIME On
SET STATISTICS IO On

SELECT * FROM A WHERE ....
SELECT * FROM B WHERE ....
SELECT * FROM C WHERE ....

SET STATISTICS TIME OfF
SET STATISTICS IO OfF

輸出範例: CPU time = 406 ms, elapsed time = 730 ms.

{%hackmd BJrTq20hE %}