Oracle Error Message
ORA-25957: join index where clause cannot contain cycles
Reason for the Error
An attempt to create a join index was made, which failed because the where clause contains a cycle.
Solution
Ensure that the where clause is in the form of a star or snowflake schema.
