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-02476: can not create index due to parallel direct load on table

1 Answers  


ORA-39956: duplicate setting for PL/SQL compiler parameter string

1 Answers  


ORA-07265: sppst: semop error, unable to increment semaphore.

1 Answers  


DRG-12203: section group string does not exist

1 Answers   Four Design,


ORA-07844: sllfop: LIB$GET_VM failure

1 Answers  


QSM-01124: set operator materialized view, string, doesn't have a marker column

1 Answers  


ORA-24199: message store is overflow

1 Answers  


SQL*Loader-00711: Internal error: bad address for little endian UTF16 conversion

1 Answers  


ORA-22856: cannot add columns to object tables

2 Answers  


ORA-00953: missing or invalid index name

1 Answers  


ORA-12215: TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA

1 Answers  


QSM-02122: compatibility mode must be 8.1 or higher

1 Answers  


Categories