>As you can see from the results of the sys(3054,12) output below, there's an index on:
> The SRO and Firm Firm_id fields
> The SRO Case_ID field
> The SRO_Status field
> The SRO Type field
>
>Sys(3054,12) Output
>

>Using index tag Sro_status to rushmore optimize table sro
>Using index tag Type to rushmore optimize table sro
>Using index tag Case_id to rushmore optimize table sro
>Using index tag _del to rushmore optimize table sro
>Rushmore optimization level for table sro: full
>Using index tag _del to rushmore optimize table firm
>Rushmore optimization level for table firm: full
>Joining table sro and table firm using index tag Firm_id
>

Try eliminating the tag on DELETED() for both tables and see if that helps.

Tamar