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

LPX-00402: invalid axisname in the XSL file

1 Answers  


ORA-00212: block size string below minimum required size of string bytes

1 Answers  


ORA-29281: invalid mode

1 Answers  


ORA-08179: concurrency check failed

1 Answers  


ORA-12666: Dedicated server: outbound transport protocol different from inbound

1 Answers  


ORA-29818: column name not properly specified

1 Answers  


ORA-01691: unable to extend lob segment string.string by string in tablespace string

1 Answers  


ORA-29834: REF datatype not supported with operators

1 Answers  


ORA-23464: flavor lacks column string of "string"."string"

1 Answers  


ORA-08264: ora_addr: cannot close nameserver

1 Answers  


O2F-00341: An error occurred for which no message is available

1 Answers  


NNL-00832: Deletes refused, name is a topology name: number

1 Answers  


Categories