Oracle Error Message
QSM-01522: a more optimal equivlanece than string was used to rewrite
Reason for the Error
Query Rewrite always chooses the most optimal equivalence based on certain parameters, such as cardinality of the equivalence, number of joins etc. The equivalence view specified was found to be less optimal.
Solution
None