Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

KUP-04009: invalid SLF handle

1 Answers  


ORA-38304: missing or invalid user name

1 Answers  


DRG-11624: invalid attribute string for string: proper range string to string

1 Answers  


ORA-25007: functions or methods not allowed in WHEN clause

1 Answers  


ORA-24398: connection pool already exists

1 Answers  






ORA-31222: DBMS_LDAP: PL/SQL - Invalid LDAP SSL authentication mode.

1 Answers  


ORA-33098: (APABBR01) A value of 'string' is not valid for the workspace object option.

1 Answers  


ORA-16608: one or more sites have warnings

2 Answers  


DRG-11872: Can't Connect To WAIS Server

1 Answers  


ORA-32010: cannot find entry to delete in SPFILE

1 Answers  


EXP-00024: Export views not installed, please notify your DBA

1 Answers  


ORA-26089: LONG column "string" must be specified last

1 Answers  






Categories