As a database administrator, if your DMBS offers the possibility of using any of the join algorithms (sort-merge join, hash join, nested loops join), which one would you use in each of the following situations:

The join condition is not equality.

The join condition is not equality and you have a B+ tree index.

The join condition is equality.