Situation: Your program loops through table A. For each table A record in the loop, you need info from a corresponding record in table B.

Is it more efficient to set a relation between the 2 tables before beginning the loop, or (within the loop) to perform a SEEK into the second table? Does the answer differ if table A has 2 records? 10 records? 1000 records?