>What exactly are your indexes on the two tables?
>Are you running with SET DELETED at what state?

SET("DELETED") is OFF.

Both tables have regular indicies on the respective fields. Example: crzplots.plot_id could be index by the following: INDEX ON plot_id TAG plot_id

BTW: See other messages in the thread for more info.

TC