1、输入sql语句,点击“查询-显示估计的执行计划”
简解执行计划的结果
Logical Operation
Estimated Operator Cost 估计运算符开销
Estimated I/O Cost 估计I/O开销
Estimated Subtree Cost 估计字数大小
Estimated CPU Cost 评估CPU开销
Estimated Number of Executions 估计执行数
Estimated Number of Rows 估计返回行数
Estimated Row Size 估计行大小
Ordered
节点ID
2、sql语句查看执行计划
set statistics profile on