When should I use an INNER -LOOP- JOIN instead of an INNER JOIN
LOOP | HASH | MERGE are Join hints, specifying that the join in the query should use looping, hashing, or merging. Using LOOP |HASH | MERGE JOIN enforces a particular join between two tables. LOOP cannot be specified together with RIGHT or FULL as a join type. You should always use INNER JOIN. Let the … Read more