ql-io/ql.io — Issue #120: join should run on par with in
Author: s3u
Created: 2011-12-02 21:39:23+00:00
State: open
Labels: annoy, med

Both the queries below should have the same exec cost

select ItemID, ViewItemURLForNaturalSearch, Location from details
where itemId in
(select itemId from finditems where keywords='mini cooper');

select e.ItemID, e.Title, e.ViewItemURLForNaturalSearch
from details as e, finditems as f
where e.itemID = f.itemID and f.keywords="mini cooper";