SQL Practice Logo

SQLPractice Online

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;