Re: How can I tune this query?????

aboyes_at_nwu.edu (Andrea J Boyes) wrote:

>When I change the "=" to ">",
>select id from cat
>where keyval in
>(select keyval from dates
>where year > 1965);
>
>the query takes 2 minutes.
>
>Andrea J Boyes
>Northwestern University, Evanston, IL. USA
>aboyes_at_nwu.edu

wouldn't this work?

select c.id
from cat c, dates d
where c.keyval = d.keyval
and d.year > 1965

if you have indexes on cat and dates for keyval this should work much faster.

Bryon Cho

-- 
INTELSAT