Tata Consultancy Services
Part of Tata Group
Engaged Employer
Tata Consultancy Services Interview Question
How do you diagnose slow query performance
Interview Answers
Anonymous
Aug 20, 2010
based on the situation and criticality, check the following things: status of the database Is it specific to single query Check memory/CPU usage Check statistics Chec the plan and see if there is any deviation Use hints
1