Originally posted by tamilselvan
AND (tptfbdr_a.codptf = 'CROSB')
AND (tptfbdr_b.codptf = 'WARTS')

What are the cardinalities of these 2 columns?
Do you analyze tables and indexes?

Try this:
ANALYZE TABLE xxxx estimate statistics sample 10000 rows
for table
for all indexes
for all indexed columns;

Then run the explain plan. Post the plans here.

Hi I cannot analyze the tables because we are using RBO..that would break our application.