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-01022: a more optimal materialized view than string was
used to rewrite



QSM-01022: a more optimal materialized view than string was used to rewrite..

Answer / guest

Cause: Query Rewrite always chooses the most optimal
materialized view based on certain parameters, such as
cardinality of the materialized view, number of joins etc.
The materialized view specified was found to be less optimal.

Action: To force using a 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-22956: The set contains no elements

1 Answers  


PLS-01468: The first argument of the like-predicate must be a column of type character string

1 Answers  


ORA-12533: TNS:illegal ADDRESS parameters

1 Answers  


ORA-15133: instance recovery required for diskgroup string

1 Answers  


NNF-04009: Usage: tns2nis <filename>

1 Answers  


SQL*Loader-00309: No SQL string allowed as part of string field specification

1 Answers  


ORA-29831: operator binding not found

1 Answers  


ORA-29537: class or resource cannot be created or dropped directly

1 Answers  


ORA-24460: Native Net Internal Error

1 Answers  


ORA-23422: Oracle Server could not generate an unused job number

1 Answers  


EXP-00076: multiple devices specified for tape output

1 Answers  


ORA-38439: invalid operation "string"

1 Answers  


Categories