QSM-01125: a more optimal set operator materialized view
than string was used to rewrite
- 1 Answers
- 2134 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: Query Rewrite always chooses the most optimal set
operator materialized view based on parameters, such as
cardinality of the set operator materialized view, number of
branches that the set operator materialized view can rewrite
etc. The set operator materialized view specified was found
to be less optimal.
Action: To force using a set operator materialized view,
consider using a rewrite hint.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-12477: greatest lower bound resulted in an invalid OS label
DRG-11733: more than one translation for the term in the specified language
LFI-00123: Cannot access file Sequentially and Randomly.
PLS-00391: undefined column 'string' in UPDATE statement
NNO-00074: downloading region from server string
PCC-02315: cannot evaluate expression as constant
DRG-10573: index string is obsolete
ORA-01043: user side memory corruption [string], [string], [string], [string]
RMAN-06112: changed datafile copy available
TNS-00023: INTCTL: missing ADDRESS(es) in config files
TNS-02502: Authentication: unable to find initialization function
ORA-29802: missing CONTEXT keyword
Oracle Errors 
