QSM-01125: a more optimal set operator materialized view
than string was used to rewrite
- 1 Answers
- 1481 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-31492: could not set session parameters for LogMiner session
NNL-00995: Unmatched responses received: number
NNL-00274: server not started, errors follow
PLS-00424: RPC defaults cannot include Package State
ORA-30946: XML Schema Evolution warning: temporary tables not cleaned up
PLS-00208: identifier 'string' is not a legal cursor attribute
RMAN-04031: initialization parameters used for automatic instance: string
ORA-15037: disk 'string' is smaller than mimimum of string MBs
KUP-04079: error fetching list of valid directories
NNL-00963: Timeouts, name TTL expired: number
ORA-06811: TLI Driver: could not set the IPX network number at init
ORA-36700: (XSRELTBL04) QDR dimension workspace object repeats.
Oracle Errors 
