Question

Question 32 4 pts When joining two tables together, the type of relationship between the fields on which you are joining matters for efficiency (i.e., how quickly you get results). Match the type of relationship and the relative efficiency generally experienced. Joining on a primary key and a related foreign key [Choose ] Joining on a primary key and an indexed field that is not a related foreign key [Choose] Joining two indexed fields that don't have a pre-defined relationship [Choose] Joining on two un-indexed fields that do not have a defined relationship [Choose ]

Options:

Third most efficient, slowest, most efficient, second-most efficient

Answer 1

$\small \color{blue}Answer:\;\;$

joining on a primary key and a related foreign key
    Most efficient
joining on a primary key and an indexed field that is not a related foreign key
    second most efficient
joining two indexed fields that don't have a pre-defined relationship
    third most efficient
joining on two un-indexed fields that do not have a defined relationship
    slowest