Checking compile and execute time

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:

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.

NoteIf 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.