Hi

You should run update stats on all tables and indexes

You should also post the plan using dbms_xplan which includes everything otherwise you wont get good respnoses from folks here

regards
Hrishy