Oracle Error ORA-25952: join index must only contain inner equi-joins

Oracle Error Message

ORA-25952: join index must only contain inner equi-joins

Reason for the Error

An attempt to create a join index was made, which failed because it included a predicate which wasn’t an equi-inner join.

Solution

Remove the inappropriate predicate.