Cause: An attempt to create a join index was made, which failed because one of the tables in the from clause did not appear in the where clause. See the solution below.
Error solution: Ensure that the where clause contains all from clause tables.
Database version: Oracle 11g Release 2 (11.2)