How would you tune a slow-running SQL query for better performance in a healthcare analytics environment?