db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Auser99 <guser999...@gmail.com>
Subject Select ... where ... IN (Select ... )
Date Wed, 17 Feb 2010 22:14:01 GMT

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.


Mime
View raw message