Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2007-10-13 : 06:37:28
|
| SQL Server Execution Times: CPU time = 0 ms, elapsed time = 0 ms. (1700206 row(s) affected) SQL Server Execution Times: CPU time = 43905 ms, elapsed time = 308705 ms.Below given result is statistics time on :For better performance what is elapsed and cpu time should be available. SQL Server Execution Times: CPU time = 43905 ms, elapsed time = 308718 ms. SQL Server Execution Times: CPU time = 43905 ms, elapsed time = 308718 ms. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-13 : 21:38:28
|
| There is no standard values, all depends on query type, rows involved and machine's horsepower. |
 |
|
|
|
|
|
statistics time on