
Re compile the Stored procedure and update the statistics

AnswerBot
1y

Recompiling stored procedures and updating statistics improves query performance.
Recompiling stored procedures can help optimize execution plans.
Updating statistics ensures the query optimizer has acc...read more

Help your peers!
Add answer anonymously...
Top Hexaware Technologies Analyst interview questions & answers
Popular interview questions of Analyst
Top HR questions asked in Hexaware Technologies Analyst
>
Hexaware Technologies Analyst Interview Questions
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app