SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-53
SET STATISTICS Command
SET STATISTICS Command
The SET STATISTICS command allows you to specify whether to display statistics
after each SQL statement executes.
ON
displays statistics automatically after each statement executes.
OFF
turns off the automatic display of statistics.
For a description of the statistics displayed, see DISPLAY STATISTICS Command on
page 4-22.
Examples of SET STATISTICS
•
To enable the automatic display of statistics, enter:
>> SET STATISTICS ON;
>> DELETE FROM persnl.employee
+> WHERE first_name =
'TIM' AND last_name = 'WALKER';
--- 1 row(s) deleted.
Start Time 2001/08/31 09:57:33.793
End Time 2001/08/31 09:57:37.268
Elapsed Time 00:00:03.476
Compile Time 00:00:02.963
Execution Time 00:00:00.513
Table Name Records Records Disk Message Message Lock
Accessed Used I/Os Count Bytes
SAMDBCAT.PERSNL.EMPLOYEE
62 1 2 2 22496 0
"\MYSYS.$SAMDB".PERSNL.XEMPDEPT
1 1 2 2 7096 0
"\MYSYS.$SAMDB".PERSNL.XEMPNAME
1 1 2 2 10784 0
•
To disable the automatic display of statistics, enter:
>> SET STATISTICS OFF;
>> DELETE FROM persnl.employee
+> WHERE first_name = 'GINNY' AND last_name = 'FOSTER';
--- 1 row(s) deleted.
SET STATISTICS {ON | OFF}
Note. The default setting when you start MXCI is STATISTICS OFF.