Hey there! This problem might be a bit unpredictable, but give it a go and let us know how you do!
Given the following SQL query executing a join between three tables in MySQL, determine which index optimizations would be most effective in improving the execution plan:
SELECT a.name, b.salary, c.department_name
FROM employees a
JOIN salaries b ON a.emp_id = b.emp_id
JOIN departments c ON a.dept_id = c.dept_id
WHERE b.date = '2023-01-01' AND a.status = 'active';