set statistics time displays information about the amount of time it takes to parse and execute Adaptive Server commands.
Parse and Compile Time 57. Adaptive Server cpu time: 5700 ms. Execution Time 175. Adaptive Server cpu time: 17500 ms. Adaptive Server elapsed time: 70973 ms.
The meaning of this output is:
Parse and Compile Time – the number of CPU ticks taken to parse, optimize, and compile the query. See below for information on converting ticks to milliseconds.
Adaptive Server® cpu time – the CPU time in milliseconds.
Execution Time – the number of CPU ticks taken to execute the query.
Adaptive Server cpu time – the number of CPU ticks taken to execute the query, converted to milliseconds.
Adaptive Server elapsed time – the difference in milliseconds between the time the command started and the current time, taken from the operating system clock.
This output shows that the query was parsed and compiled in 57 clock ticks. It took 175 ticks, or 17.5 seconds, of CPU time to execute. Total elapsed time was 70.973 seconds, indicating that Adaptive Server spent some time processing other tasks or waiting for disk or network I/O to complete.
If a query is complex and takes a long time to run,
check if Execution Time is high because of a suboptimal plan or
that Parse and Compile Time is high because of optimization performance.
