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-26080: file "string" is not part of table string.string partition string

1 Answers  


ORA-23389: obsolete procedure; drop objects and recreate using new master

1 Answers  


LSX-00273: invalid character "~c" in base64-encoded binary

1 Answers  


ORA-30181: integer in argument index is not immediately followed by )

1 Answers  


SQL*Loader-00509: System error: string

1 Answers  


ORA-00225: expected size string of controlfile differs from actual size string

1 Answers  


RMAN-06548: connected to auxiliary database: string (DBID=string)

1 Answers  


DRG-11805: Accepted

1 Answers  


ORA-27039: create file failed, file size limit reached

1 Answers  


ORA-07646: sszfck: $CREATE failure

1 Answers  


ORA-19734: wrong creation SCN - control file expects converted plugged-in datafile

1 Answers  


ORA-07507: scgcm: unexpected lock status condition

1 Answers  


Categories