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

RMAN-07517: Reason: The file header is corrupted

2 Answers  


ORA-24075: cannot specify agent with NULL address and non-NULL protocol

1 Answers  


ORA-33262: (DBERR01) Analytic workspace string does not exist.

1 Answers  


ORA-31461: logfile location string contains no files that match pattern string

1 Answers  


KUP-03003: absolute end(number) - start(number) != fieldlength (number) for field string

1 Answers  


ORA-37010: (XSACQUIRE_DIFFAW) When using CONSITENT WITH clause, all objects must come from the same analytic workspace.

1 Answers  


ORA-02246: missing EVENTS text

1 Answers  


ORA-01189: file is from a different RESETLOGS than previous files

1 Answers  


DRG-11850: Transformation Applied

1 Answers  


PCC-01007: WORKING-STORAGE SECTION not found

1 Answers  


O2I-00125: Error writing to the INITFILE file

1 Answers  


NPL-00308: requested ASN.1 class string does not match received class string

1 Answers  


Categories