John,

The first part describes optimization of the filter conditions. You have only one WHERE INMATES.CSTATUS='OPEN' and it's not optimizable because there's no index on INMATES.CSTATUS.
What result did you expect to get?

>
>I tried that. I still get the same results as before with some additional information about the joins:
>
>Joining table inmates and table cells using index tag id
>Joining intermediate result and table classifications using index tag id
>Joining intermediate result and table bill_codes using index tag id
>
>As stated earlier, each table has 1 index and the tagname is ID.
>