db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamatha Kodigehalli Venkatesh" <Mamatha.Venkat...@ness.com>
Subject Derby hangs when joins are used specially for larger resultset
Date Thu, 01 Apr 2010 13:32:30 GMT 
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
Mime
View raw message