In Derby, when user Select ... where ... IN (Select ... ), it runs extremely slow, even though both selects are have optimized indeces (the primary keys). Can someone suggest a get-around rather than run the queries one at a time? Thanks.
http://www.xprad.com gu -- View this message in context: http://old.nabble.com/Select-...-where-...-IN-%28Select--...-%29-tp27631171p27631171.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
