I have a large (=many records) table A and a small table B.
I want to compare all values of text-field X in A with those in B.
Two ways of course:
1. Value A1 search in B, value A2.. etc or
2. Value of B1 search in A etc.
1 means more, but smaller searches
2 means fewer larger searches
Q1 Is there any reason why scripting-wise one of the two methods is better?
Q2 Is there any (theoretical) difference in time-to-finish?
All input helpful!