All Forums Database
gmathias 1 post Joined 03/15
22 Mar 2015
Stored Procedure taking more time than usual

Hi,
What are the things that I should look for when a stored procedure takes more time to execute than usual.
I understnd that stale stats can be the primary issue for such occurences but apart from that can there there be any other issues which can be resolved?
 
Thanks,
Gordon 

MaximeV 19 posts Joined 11/13
23 Mar 2015

hello,
Could be lock issues. Do you query tables or views?

teradatauser2 236 posts Joined 04/12
23 Mar 2015

If there is an insert/update, please check if the data is not skewed i.e it is being inserted/updated to only few amps.
--Samir

You must sign in to leave a comment.