Hi Todd,

You can try

* JOIN
SELECT cr.plot_id ;
	FROM crzplots cr ;
	JOIN  imsfilter ON linkfield = cr.plot_id ;
	INTO CURSOR cPlots

* Correlated subquery
SELECT plot_id ;
	FROM crzplots ;
	WHERE EXISTS (SELECT *  FROM imsfilter WHERE linkfield = plot_id) ;
	INTO CURSOR cPlots

>Having never checked, I thought the following SQL was Rushmore optimized.
>This SQL is highly simplified and the actual SQL included fields not seen here. The results are the same though.

>SELECT plot_id ;
>  FROM crzplots ;
>  WHERE plot_id in (SELECT linkfield FROM imsfilter) ;
>  INTO CURSOR cPlots

>Given that the table crzplots has a field called plot_id and it is indexed and the same for the table imsfilter with the field linkfield.
>
>As crzpltos grew, the SQL was taking longer and longer. Looking throught the threads in UT, I noticed several threads refere to SYS(3054). I tried it and was told that the optimization level for both tables was none.
>
>Can this SQL be optimized. Please keep in mind that there are other fields in crzplots. I have deleted the extra fields for clarity. Secondly, crzplots is running about 1 million records and imsfilter can be any number between 1 and RECC("crzplots").