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

TNS-12676: Server received internal error from client

1 Answers  


RMAN-08030: allocated channel: string

1 Answers  


ORA-01781: UNRECOVERABLE cannot be specified without AS SELECT

1 Answers  


PCC-02434: FOR clause not permitted in any LOB statement

1 Answers  


ORA-08113: composite partition index may not be compressed

1 Answers  


PCC-00047: Unterminated comment/string constant beginning near line number in file string

1 Answers  


ORA-14165: MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations

1 Answers  


ORA-30765: cannot modify scope for an unscoped REF column

1 Answers  


ORA-32118: Cannot perform operation on a null FILE

1 Answers  


ORA-19026: EXTRACTVALUE can only retrieve value of leaf node

1 Answers  


ORA-23334: column string does not exist in table or column group

1 Answers  


ORA-36930: Cannot start a recursive call to Oracle OLAP because a ROLLBACK past an UPDATE to an attached analytic workspace has been performed.

1 Answers  


Categories