I have stored procedure which is based on tables that one of them has nearly 4M records and is being updated constantly. After a nearly a month my report which is using this stored procedure become very slow. Runs for ever. If I am recompiling the stored
procedure then everything is fine and everyone is happy.
Do I need to add "With Recompile" to the beginning of this stored procedure or I need to create a job which every week or so will recompile this stored procedure automatically.
P.S. This report is being run mostly and maybe average is being called 15 times per hour on regular days. In closing day maybe more.
Any suggestion would be nice and helpful.
Thanks in advance.
Best Wishes, Arbi --- Please vote if you find this posting was helpful or Mark it as answered.
View Complete Post