I have a query like select .... from a,b where a.col=b.col
and a.col1=xxx. Both tables are very large.

My problem is that oracle CBO is first doing join then applies filter. I want it to do other way round. I can do it by re-phrasing the query.

Am I missing some settings in init.ora? Why is CBO always doing hash join on tables and then filtering. The query takes over & over and as per its estimate will take 120 hours!

Please help.

Kailash pareek