Great! Glad to hear that worked.
It is possible that a query can skip the master map completely, but only if all fields being selected are in the index and in the same form as in the master map.
Even if all fields are in an index, indexed fields are typically stored in SQLUPPER, required for SQL comparisons, but the query must get the fields in their original form for output. So for a SELECT *, the query will almost always need to go back to the mastermap.
To leave a comment or answer to post please log in
Please log in