Chao Cao
05/01/2025, 12:46 AMSET maxRowsInJoin = 10,000,000;
SELECT
price.amount,
price.offerId,
price.sellerId,
price.itemId
FROM price
LEFT JOIN offer
ON price.sellerId = offer.sellerId
AND price.offerId = offer.offerId
WHERE
offer.internal_item_id = <valid_id>
OR price.itemId = <valid_id>Chao Cao
05/01/2025, 12:50 AMSELECT price, offerId, sellerId, itemId
FROM
(SELECT price, offerId, sellerId, itemId
FROM price
WHERE itemId = <valid_id>) AS price
LEFT JOIN
(SELECT sellerId, offerId, internal_item_id
FROM offer
WHERE wmart_item_id = <valid_id>) AS offer
ON
price.sellerId = offer.sellerId
AND price.offerId = offer.offerId;
Does anyone have an idea on what I can do to get my queries to execute when joining two very large tables?Xiang Fu
Xiang Fu
Xiang Fu