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

TNS-01161: Spawn alias string was not found. Check listener parameter file

1 Answers  


ORA-36612: (XSLMS01) An application attempted to retrieve a non-existent user message. (Product: value, Facility: value, Message Number: value)

1 Answers  


ORA-01903: EVENTS keyword expected

1 Answers  


ORA-03210: DBMS_ADMIN_PACKAGE invalid option specification

1 Answers  


ORA-29285: file write error

1 Answers  






ORA-02816: Unable to kill a process

1 Answers  


TNS-12696: Double Encryption Turned On, login disallowed

1 Answers  


ORA-36992: (XSRELGID09) A level relation is needed to produce a surrogate dimension gid.

1 Answers  


ORA-01344: LogMiner coordinator already attached

1 Answers  


ORA-00162: external dbid length string is greater than maximum (string)

1 Answers  


ORA-23313: object group "string"."string" is not mastered at string

1 Answers  


NCR-01006: NCRS: Data buffer overflow.

1 Answers  


Categories