Level 1 - BeginnerOptimization Questions
Optimization-Lite: Pick Better Query
Choose the better query for performance and maintainability, then provide the final SQL. Query A: SELECT * FROM employees WHERE UPPER(name) = 'JOHN SMITH'; Query B: SELECT id, name, department FROM employees WHERE name = 'John Smith';