Join algorithms are required when more than one table appears in the FROM clause. You cannot specify which join algorithm is used--the choice is made by the optimizer.