Joining Forces: Tuning Database Engines

Report a typo
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';
Select one or more options from the list

Create a free account to access the full topic