Hi,

Which of the two query options is better?

SELECT a.item_id, a.create_dt
FROM   a JOIN b
ON     (a.item_id = b.item_id)
WHERE  a.item_id = 'I001'
AND    a.category_name = 'C001';

- or -

SELECT a.item_id, a.create_dt
FROM   a JOIN b
ON     (a.item_id = b.item_id AND a.item_id = 'I001')
WHERE  a.category_name = 'C001';

Thanks
Naga

Reply via email to