>
The results are probably telling me that the joins are optimized and I just do not understand the results.
>
>The total results:
>
>Rushmore optimization level for table inmates: none
>Rushmore optimization level for table cells: none
>Rushmore optimization level for table classifications: none
>Rushmore optimization level for table bill_codes: none
>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
>
>So I guess that means the joins are optimized because it says it is using an index but is confuses me because it also says "optimization level for table cells: none", etc. The VFP does not provide much info on how to read the results.
<snip>

John,

Looks like we're going in circles on this one.
Quote from my previous message:
"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".
The first part it's the one that starts with "Rushmore optimization level".
If there was index on INMATES.CSTATUS, the level of optimization for INMATES table would be 'partial', as Mike explained in other message in this thread, because of missing index on DELETED().

The second part, that starts with "Joining", describes JOIN optimization. In the case of your query, as I poined out before, all JOIN's are optimized becasue they're using indexes.