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

RMAN-06164: WARNING: no channel of required type allocated to recover datafile number

1 Answers  


TNS-00034: INTCTL: internal NR error

1 Answers  


ORA-23338: priority or value already in priority group string

1 Answers  


LSX-00206: substitution for element "~S" is disallowed

1 Answers  


PLS-01421: FOR UPDATE clause

1 Answers  






PCB-00108: Unable to open list file "string"

1 Answers  


DRG-10703: invalid framework object string

1 Answers  


PCC-01012: DATA DIVISION not found

1 Answers  


ORA-09761: pw_destroyPorts: server call pws_stop_instance failed.

1 Answers  


PCB-00502: This statement can only be used with THREADS=YES

1 Answers  


NZE-28824: invalid encryption/decryption/signature state passed

1 Answers  


PLS-00572: improper constraint form used

1 Answers   IBM,


Categories