db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: Derby 10.5.3: subquery performance using "IN"
Date Sun, 22 Nov 2009 02:43:38 GMT
Does it help if you first SELECT the inner rows into a temporary
table, and then do a SELECT * from that tmp table in the IN subquery?

Dag

Mime
View raw message