How can I tune this query?????

I have a query:

select id from cat
where keyval in
(select keyval from dates

where year = 1965);

This takes < 5 seconds running against the 300,000 row tables.

When I change the "=" to ">",
select id from cat
where keyval in
(select keyval from dates

where year > 1965);

the query takes 2 minutes.

Year is type NUMBER and is indexed. Any thoughts on how to speed this up?

Thanks in advance for any help!

Andrea J Boyes
Northwestern University, Evanston, IL. USA aboyes_at_nwu.edu Received on Wed Mar 27 1996 - 00:00:00 CET