Derby hangs when joins are used specially for larger resultset

[Mamatha Kodigehalli Venkatesh]

Hello,

 

Derby just cannot process the below query through ij editor and it just hangs, 
whereas in oracle it just takes 2 sec's.

Derby and Oracle are reflecting the same data.

There are around 46 thousand records that oracle fetches using this query.

 

SELECT count (*) FROM TIDLRREP LRREP, TIDLGGLS LGGLS WHERE UPPER 
(LRREP.SOURCE_TYPE) = 'COPYBOOK  ' AND UPPER(LRREP.BASE_LANGUAGE_TERM) = 
UPPER(LGGLS.BASE_LANGUAGE_TERM);

 

Any feedback on this, Cost Based Optimizer forcing an index for column 
LRREP.BASE_LANGUAGE_TERM is also not of any help.

 

Please advise how to make the joins work smoother.

 

Thanks

Mamatha