I'm trying to get the query below to run quicker - what am I missing? I thought if it was indexed that Rushmore would speed this query up. I have custnum and cnum indexed. The nested query returns about 16,000 records pretty quickly, but it looks like the 'custnum in' doesn't benefit from Rushmore at all.

lcList = ["1000000221","1000000222","1000000223","1000000224"]

sele EMAIL,NAME,MEDIA,CUSTNUM from customer ;
 where custnum in (sele custnum from current where cnum IN (&lcList)) into cursor a2

9306 records. A2 elapsed time: 240.333

Rushmore optimization level for table customer: none
Using index tag Cnum to rushmore optimize table current
Rushmore optimization level for table current: full
Joining table customer and table current using index tag Custnum

TIA,

E.R. Gilmore