In an OLTP environment, if a query joins two tables on their primary key, which of the following join methods is preferred?

A. Hash join

B. Star join

C. Merge join

D. Nested-loop join