>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").
What exactly are your indexes on the two tables? Are you running with SET DELETED at what state?