QSM-01125: a more optimal set operator materialized view
than string was used to rewrite
- 1 Answers
- 2422 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-06043: NETDNT: message send failure
ORA-16704: Cannot set the property because it is read-only
ORA-30344: number of child cols different from number of parent level cols
ORA-13864: Statistics aggregation for service (module/action) string is already enabled
IMG-00586: output format does not support the specified pixelOrder
ORA-25019: too much concurreny
ORA-06113: NETTCP: Too many connections
ORA-36810: (XSTBLFUNC05) Analytic workspace object number does not exist.
NZE-29026: Decryption failure
DRG-11522: no row exists for the text key(s) specified
ORA-22285: non-existent directory or file for string operation
ORA-13240: specified dimensionality greater than that of the query mbr
Oracle Errors 
