QSM-01022: a more optimal materialized view than string was
used to rewrite



QSM-01022: a more optimal materialized view than string was used to rewrite..

Answer / guest

Cause: Query Rewrite always chooses the most optimal
materialized view based on certain parameters, such as
cardinality of the materialized view, number of joins etc.
The materialized view specified was found to be less optimal.

Action: To force using a materialized view, consider using a
rewrite hint.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-04020: deadlock detected while trying to lock object stringstringstringstringstring

1 Answers  


ORA-24330: internal OCI error

1 Answers  


RMAN-06542: file string is excluded from whole database backup

1 Answers  


ORA-22883: object deletion failed

1 Answers  


ORA-23365: site string does not exist

1 Answers  






ORA-24019: identifier for string too long, should not be greater than string characters

1 Answers  


DRG-11818: Temporary Redirect

1 Answers  


TNS-12571: TNS:packet writer failure

1 Answers  


ORA-31021: Element definition not found

1 Answers  


TNS-04209: Trace Assistant Internal ERROR: Type Error

1 Answers  


ORA-32816: foreign queue string is referenced by a subscriber or schedule

1 Answers  


ORA-33074: (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.

1 Answers  


Categories