How do you measure the performance of a stored procedure?
Answers were Sorted based on User's Feedback
Answer / balaji l
Run the query execution plan if the sp is optimized or not.
Optimize the query if it takes more time. Check the cpu i/o
time usage.
Is This Answer Correct ? | 13 Yes | 7 No |
Answer / jayagopal p.s
Run the sp and check the response time of that sp.If it
takes a long time to response then optimize the query to
reduce the time usage.
Is This Answer Correct ? | 4 Yes | 1 No |
Determine how to use the inserted and deleted pseudo tables?
How many types of cursor type are there?
What are different types of subquery?
Explain what is scheduled job and how to create it?
Explain system scalar functions?
What are the steps to follow to configure SQL*Net?
Explain what are the authentication modes in sql server?
Tell me what is use of except clause? How it differs from not in clause?
What are different types of views?
What is the native system stored procedure to execute a command against all databases?
How to perform key word search in tables?
What is triggers and its types?