SELECT /*+ use_hash (doi,seg) */
doi.ORDER_ID AS "PO"
, doi.DISTRIBUTOR_ID AS "Vendor ID"
, doi.ISBN AS "ASIN"
, doi.QUANTITY_ORDERED AS "Quantity Confirmed"
FROM D_DISTRIBUTOR_ORDER_ITEMS doi
JOIN    (SELECT /*+ use_hash */
    psm.ASIN
    FROM PRODUCT_SEGMENT_MEMBERSHIP psm
    WHERE psm.SEGMENT_ID = 784885) seg
ON doi.ISBN = seg.ASIN
WHERE doi.ORDER_DAY = '2009/04/06'
ORDER BY seg.ASIN