Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-06579: Bind variable not big enough to hold the output value

1 Answers  


ORA-22328: object "string"."string" has errors. string

1 Answers  


ORA-36980: (XSRELGID02) Variable workspace object must have a numeric data type.

1 Answers  


PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted

1 Answers  


PLS-01907: : number precision too large

1 Answers  


ORA-07619: $IDTOASC failed translating an integrity level

1 Answers  


ORA-19704: file name exceeds maximum length of string

1 Answers  


NNL-00273: server successfully started

1 Answers  


SQL*Loader-00952: Error calling once/data file initialization

1 Answers  


PCB-00102: Input file name length exceeds the maximum length

1 Answers  


ORA-25121: MINIMUM EXTENT value greater than maximum extent size

1 Answers  


ORA-13157: Oracle error ORAstring encountered while string

1 Answers  


Categories