>I was looking over an old program the other day. There were a series of SQL select statements that looked pretty solid. However, before these statements there was a Set Relation To between the same tables that the SQL is being preformed on. Will this degrade the performance of the SQL since the record pointer for the second table is now moving each time the parent table record pointer is moved?
Michael,
Nope, the SQL uses each table again in a new work area for tis processing. The set relations have absolutely no affect on the SQL at all.