I ran sys(3054,11) and it return following info:

Using index tag Unemp_ins_ to rushmore optimize table payroll_tbl
Rushmore optimization level for table payroll_tbl:
full
Rushmore optimization level for table payroll_tbl:
none
Rushmore optimization level for intermediate result:
none
Joining table payroll_tbl and intermediate result using temp index.

Does this mean the inner query was not optimized?

Thanks
Nick Patel