Can anyone tell of how to check the time of execution of a stored procedure in SQL 2000 and do any one have any idea of the steps for query optimization? Thanks in advance.

--Siva--