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


QSM-01125: a more optimal set operator materialized view
than string was used to rewrite



QSM-01125: a more optimal set operator materialized view than string was used to rewrite..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-31492: could not set session parameters for LogMiner session

1 Answers  


NNL-00995: Unmatched responses received: number

1 Answers  


NNL-00274: server not started, errors follow

1 Answers  


PLS-00424: RPC defaults cannot include Package State

1 Answers  


ORA-30946: XML Schema Evolution warning: temporary tables not cleaned up

1 Answers  






PLS-00208: identifier 'string' is not a legal cursor attribute

1 Answers  


RMAN-04031: initialization parameters used for automatic instance: string

1 Answers  


ORA-15037: disk 'string' is smaller than mimimum of string MBs

1 Answers  


KUP-04079: error fetching list of valid directories

1 Answers  


NNL-00963: Timeouts, name TTL expired: number

1 Answers  


ORA-06811: TLI Driver: could not set the IPX network number at init

1 Answers  


ORA-36700: (XSRELTBL04) QDR dimension workspace object repeats.

1 Answers  






Categories