1. "SET STATISTICS TIME ON"/"SET STATISTICS TIME OFF "
用于統計SQL指令執行的時間,如:

2. "SET STATISTICS IO ON" / "SET STATISTICS IO OFF"
用于統計IO情況,如:
3. "SET STATISTICS PROFILE ON" / "SET STATISTICS PROFILE OFF"
用于分解一個SQL指令的詳細執行計劃,便于深入了解SQLServer底層的執行過程,提供優化方向