Optimizer - subqueries

[Jake Day]

Hi,

Can anyone advise if its possible to force the optimizer to perform subqueries before the "outer" query.

I've got a few queries that should run and complete in less than 45 seconds, but are being "killed" after 10 mins+.

The explain shows that the query is running the "outer" part first, and then the subquery. I want it to run the subquery first.

For example,

Select * from header a, detail b where a.id = b.id
and a.id in (select id from c)

c is a "daily" table, so only has a subset of data on it. But the optimizer insists on doing the a/b match first, rather than doing the subselect?

If anyone can advise how to get the subquery to run first it would be most apppreciated.

Thanks

jake