July 12, 2005 at 8:01 am
I am looking for a way to add the query execution time to the result of the query. This is not a big deal, but if anyone knows of a setting in query analyzer or an SP or routine for adding this, I would greatly appreciate it. Thanks in advance.
Jeff
July 12, 2005 at 8:15 am
Is this for the final application or for query optimization??
SET STATISTICS TIME ON
Select * from dbo.SysObjects
SET STATISTICS TIME OFF
check the message window.
July 12, 2005 at 10:38 am
Thank you. This was exactly what I needed.
Jeff
July 12, 2005 at 10:45 am
HTH.
check out SET STATISTICS IO too .
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply