本文介绍如何使用settimeon/off及settimingon/off命令来查看SQL语句的执行时间，包括大概时间和精确时间。
1）查看SQL执行操作时间
显示大概时间：set time on/off
显示精确时间：set timing on/off
显示精确时间：set timing on/off
示例如下
SQL> set time on
15:16:06 SQL> select * from test;
NAME ID MALE
-------------------- ---------- ----------
jack 1234567890 1
Elapsed: 00:00:00.44
15:16:12 SQL> set time off
SQL> set timing on
SQL> select * from test;
NAME ID MALE
-------------------- ---------- ----------
jack 1234567890 1
Elapsed: 00:00:00.00
SQL> set timing off
SQL>
15:16:06 SQL> select * from test;
NAME ID MALE
-------------------- ---------- ----------
jack 1234567890 1
Elapsed: 00:00:00.44
15:16:12 SQL> set time off
SQL> set timing on
SQL> select * from test;
NAME ID MALE
-------------------- ---------- ----------
jack 1234567890 1
Elapsed: 00:00:00.00
SQL> set timing off
SQL>
2）
扫一扫
747
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
