Precisely Interview Question

How do you troubleshoot a slow running query in a database?