> I am working with Derby 10.2.2.  This SQL query has an unacceptable
> performance:
> 
> SELECT * FROM registryobject WHERE id IN (SELECT targetObject FROM
> association WHERE UPPER(sourceobject) = UPPER(?))
> 
> Is this a bug in derby or something else?  Am I missing something?

https://issues.apache.org/jira/browse/DERBY-47

Fixed in 10.3.0.0.

Reply via email to