---
# System prepended metadata

title: Untitled
tags: [Sql, '2022']

---

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


#SQL 監測IO、時間效能

```sql
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 %}