Can you post the number of extents for each table and index
and also the explain plan for the query.

Cheers

Paul