All else equal, a query will return results the fastest when

A. There is a primary key and foreign key relationship established between the tables being joined.

B. One table has a primary key, and the other has a related field with an index.

C. One table has a primary key, and the related field in the other table is unindexed and not a foreign key.