Stored Procedure taking more time than usual

Database

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 

2 REPLIES
Teradata Employee

Re: Stored Procedure taking more time than usual

hello,

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

Enthusiast

Re: Stored Procedure taking more time than usual

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