SELECT o.order_id, c.customer_name, p.product_name, o.quantity
FROM orders o
JOIN customers c ON o.customer_id = c.id
JOIN products p ON o.product_id = p.id
WHERE c.region = 'East' AND p.category = 'Electronics'
ORDER BY o.order_date DESC
LIMIT 20;
在EXPLAIN输出中,优化器选择了customers作为驱动表。以下哪种情况最可能导致这个选择?
