Level 5 - SeniorOptimization Questions
Optimization: Join Key Data Type Mismatch
Interviewer prompt: Which query avoids implicit cast on join key? Query A: SELECT * FROM orders o JOIN customers c ON o.customer_id::TEXT = c.customer_id_text; Query B: SELECT * FROM orders o JOIN customers c ON o.customer_id = c.customer_id;