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

DRG-11102: assigned lexer can not operate on string language setting

1 Answers  


ORA-26716: message limit reached

1 Answers  


ORA-06268: NETNTT: cannot read /etc/oratab

1 Answers  


EXP-00041: INCTYPE parameter is obsolete

1 Answers  


ORA-30514: system trigger cannot modify tablespace being made read only

1 Answers  


ORA-07286: sksagdi: cannot obtain device information.

1 Answers  


ORA-24102: invalid prefix for generate_job_name

1 Answers  


ORA-00294: invalid archivelog format specifier 'string'

1 Answers  


ORA-19008: Invalid version of the XMLType

1 Answers  


ORA-09360: Windows 3.1 Two-Task driver unable to allocate context area

1 Answers  


ORA-27086: unable to lock file - already in use

1 Answers  


ORA-06321: IPA: Cannot reach the remote side

1 Answers  


Categories