Help on Query Analyser

[samkud]

Hi Everybody,

I am executing the following query in the query analyser.

"select * from alien119700 order by alienid"

In the message pane it shows

SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 4 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.

(43 row(s) affected)


SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 454 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.


What does all this mesaages mean?

Can anyone explain this to me?

Thanx in advance.

Regards,

Samir.

[skhanal]

This tells you how much time sql server spent in compiling, parsing and executing the query.

CPU time is the time CPU was busy working on your query, elapsed time is total time to execute the query.